2
Reply

Splitting commas in a string

priya priya

priya priya

Aug 24 2009 8:27 AM
2.5k
Hi,

i want to know if i give some value like this:

select * from split('11,12|13,15|16,18')

i should get the output as

Id  Value1  Value2
1  11  12
2  13  15
3  16  18

please help me ,how to do this in sql server 2005

Thanks in advance




Answers (2)