Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 Split Semi-Comma Delimited Field

Author  Topic 

bholmstrom
Yak Posting Veteran

76 Posts

Posted - 2013-06-28 : 14:29:57
Good afternoon,

I have a table that has a field that has been populated with a set of values seperated by a semi-colon

Example:

Joyce Price; Sheslie Royster; David Norton

I would like to seperate these into a single field temp table.

The field contains random number of entries.

Thank you in advance for your assistance.

Bryan Holmstrom

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-06-28 : 14:39:15
Use a string splitter - the best one out there is Jeff Moden's DelimitedSplit8K - which you can dowload from here: http://www.sqlservercentral.com/articles/Tally+Table/72993/
Go to Top of Page
   

- Advertisement -