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

We can set a row delimiter for a Flat File Connection in SSIS.but the question is how to set multi… Read more Set Multiple Row Delimiters In Flat File Connection