Select a column in a comma separated row in SQL

eceramanan

4.29/5 (6 votes)

May 6, 2011

CPOL

25755

How to select a column from a comma separated row in SQL

declare @list varchar(max)
select @list=COALESCE(@list+', ','')+ COLUMN_1 from TABLE_1
select @list