Parse a SQl Column into multiple columns

[klewis10367]

I have a sql table that contain a column with text that has commas in it. They are used to seperate the data within the column. i wan to be able to create a column for each commas seperated text value. I am using SQl 2005. Below is an example of the text field:

17 N., w/s of NMB Flea Mkt., e/s

What i want from this is 3 new columns;

Column 1 Column 2 Column 3
17N. w/s of NMB Flea Mkt. e/s

 

[genomon]

Wow. Any chance you can go back and design a table structure that conforms to some kind of normalization?

Otherwise, have a look here: faq183-1151


Ni neart go cur le cheile.

 

[markros]

Take your pick from any function here

http://sqlblog.com/blogs/aaron_bert...tting-a-list-of-integers-another-roundup.aspx

(just change to return character instead of integer)

PluralSight Learning Library