Select a column in a comma separated row in SQL

pankajupadhyay29

Rate me:

5.00/5 (1 vote)

10 May 2011CPOL

9.5K

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.

1. Select a column in a comma separated row in SQL

9 May 2011eceramanan

1 alternative

How to select a column from a comma separated row in SQL

SQL

MySQL

License

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

Written By

pankajupadhyay29

Architect

India

• An Architect, developer, trainer, and student
• 10 years of experience in Architecture and Development of enterprise applications
• Extensive knowledge in designing and developing Web-based enterprise applications using open source and Microsoft Technologies
• Extensive experience in Angular, AngularJS, ReactJs, NodeJs, JavaScript, ASP.Net, C#, CSS, HTML

Select a column in a comma separated row in SQL

Alternatives

License

Comments and Discussions