Lab Sql

Here is my table structure: id PaymentCond 1 ZBE1, AP1, LST2, CC1 2 VB3, CC1, ZBE1 I need to spl… Read more Sql: Split Comma Separated String List With A Query?

This MySQL script installs multiple triggers. It works on one machine running MySQL 5.0.51b-commun… Read more Mysql Delimiter Syntax Errors

So someone gave me a spreadsheet of orders, the unique value of each order is the PO, the person th… Read more Split Delimited Entries Into New Rows In Access

I have a string like this that doesn't have a consistent format and needs to be broken into fie… Read more No Functions, No Split_string. Use Xml To Split String Into Different Fields By Delimiter

I followed the instructions outlined in this post to split a delimited string into rows of a table:… Read more Sql Regexp_substr Returns Null String When Splitting

I need to split my one column value in column using delimiter, below is the table structure. create… Read more Split String In Columns By Delimiter Using Sql Server