Splitting commas in a string

Question

Hi i want to know if i give some value like this: select * from split('1112|1315|1618') 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

priya priya · Answer

If i give a value like this '1112|1314|1516' I want to write a function in sql to remove that '' and '|' and i need my output as follows: id value1 value2 1 11 12 2 13 14 3 15 16 thanks in advance

Roei Bar · Answer

you can do it by using pivot capability like this SELECT * FROM TableName t CROSS APPLY dbo.udf_PivotParameters(t.fieldnamewithcommas '') just insert the values to a temptable the pivot it with the code attached above remember to mark this as Accepted Answer