Click here to Skip to main content
15,557,873 members
Articles / Database Development / SQL Server

Tagged as


10 bookmarked

Converting comma separated data in a column to rows for selection

Rate me:
Please Sign up or sign in to vote.
4.88/5 (5 votes)
24 Feb 2014CPOL1 min read
If you have an SQL column which contains a comma separated list of names, you may have wondered how to return it as individual rows in a SELECT statement. It's not too bad, really!


Daily Counts


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

Written By
Wales Wales
Born at an early age, he grew older. At the same time, his hair grew longer, and was tied up behind his head.
Has problems spelling the word "the".
Invented the portable cat-flap.
Currently, has not died yet. Or has he?

Comments and Discussions