3
Reply

splitting commas in a string

priya priya

priya priya

Aug 25 2009 2:54 AM
3.3k
If i give a value like this


'11,12|13,14|15,16'

I want to  remove that ',' and '|' and i need my output as follows:


id value1 value2
1     11        12
2     13        14
3     15        16

I want to achieve this by inserting values in temporary table and by using charindex in sql server
thanks in advance

Answers (3)