Convert String separated with comma to list

Question

1.00/5 (1 vote)

See more:

Convert 'xxx,yyy,zzz'
into 'xxx','yyy','zzz'

by sql 2008

Posted 13-Jul-13 23:32pm

Comments

[no name] 14-Jul-13 6:35am

Not a question or description of any kind of a problem.

2 solutions

The question, answered:

DECLARE @strIn [nvarchar](2008)
SET @strIn = 'xxx,yyy,zzz'

A SELECT query:

SELECT REPLACE(REPLACE(REPLACE(@strIn,',',''','''),'xxx''','''xxx'''),'''zzz','''zzz''') As [simple]

If I misunderstood, I wouldn't post this as an answer.

[simple]
~~~~~~~~~~~~~~~~~
'xxx','yyy','zzz'

Posted 15-Jul-13 7:18am

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Asif_ · Accepted Answer · 2013-07-13T23:35:00

Posted 13-Jul-13 23:35pm