priya priya

priya priya

  • NA
  • 17
  • 101.4k

Splitting commas in a string

Aug 24 2009 8:27 AM
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)