Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / database / MySQL

Select a column in a comma separated row in SQL

4.29/5 (6 votes)
9 May 2011CPOL 25.8K  
How to select a column from a comma separated row in SQL
SQL
declare @list varchar(max)
select @list=COALESCE(@list+', ','')+ COLUMN_1 from TABLE_1
select @list

License

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