Converting comma separated data in a column to rows for selection

OriginalGriff

Rate me:

4.88/5 (5 votes)

24 Feb 2014CPOL1 min read

65.3K

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!

Views

Daily Counts

License

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

Written By

OriginalGriff

CEO

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?

Converting comma separated data in a column to rows for selection

Views

License

Comments and Discussions