In one of my previous posts I wrote about “ How to Create a Comma Delimited List ”.  Now I’ll show you an example with reverse action, that is Splitting a Comma Delimited String or array() of values.   There can be different types of Delimiters also : like Comma ' , ', vertical bar ' | ', Single space or a Tab.   For example here is our Sample Table -               Id         AllNames                   1         A,B,C                   2         A,B                   3         X,Y,Z           And here is the expected output -               Id         Names                   1         A                   1         B                   1         C                   2         A                   2         B                   3         X                   3         Y                   3         Z Create Sample Data :                        -- Create Table for  Sample Data               CREATE TABLE  Test              (              ID INT ,              AllNames VARCHAR (100...