priya priya

priya priya

  • NA
  • 17
  • 101.5k

splitting commas in a string

Aug 25 2009 2:54 AM
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)