Click here to Skip to main content
Click here to Skip to main content

Tagged as

Go to top

Select a column in a comma separated row in SQL

, 10 May 2011
Nice one but it did not handle null values you can change it as following to handle null valuescreate table #TABLE_1 (COLUMN_1 varchar(5))insert into #TABLE_1select 'A'union allselect 'B'union allselect 'C'union allselect 'D'union allselect 'E'union allselect...

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

9 May 2011
eceramanan
1 alternative  
How to select a column from a comma separated row in SQL

License

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

Share

About the Author

code in play
Software Developer (Senior)
India India
4+ year experience in Microsoft technologies(C#.Net,ASP.Net, SQL server and Sharepoint).
Follow on   Twitter

| | Privacy | Mobile
Web03 | 2.8.140922.1 | Last Updated 11 May 2011
Article Copyright 2011 by code in play
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid