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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-11 : 00:46:25
|
| mo writes "I have a field with multiple entries, such as a b d, seperated by space between each item. I need to split that field into three different records, with the rest of the fields being the same, but with one record for each entry.so the output would be abdI tried a few ways, and I can do this using several progamming languages, but i want to do it on the DB side.Thanks." |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-03-11 : 00:46:25
|
| This article (http://www.sqlteam.com/item.asp?ItemID=637) has a proc that will do this for you. You might also look at these: http://www.sqlteam.com/SearchResults.asp?SearchTerms=csv |
 |
|
|
|
|
|
Record Split