Click here to Skip to main content
13,052,558 members (62,621 online)
Click here to Skip to main content

Tagged as

Stats

6.7K views
1 bookmarked
Posted 10 May 2011

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...

Views

Downloads

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).

You may also be interested in...

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170713.1 | Last Updated 11 May 2011
Article Copyright 2011 by code in play
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid