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 |
|
cognos79
Posting Yak Master
241 Posts |
 Posted - 2006-12-21 : 16:36:23
|
| I do have a string with comma separated values e.g. 1,2,3is there a function in sql server tht gives me the values one by one or do I have to loop through the string using substring kinda thing.result: 1 2 3 Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-21 : 17:25:59
|
| http://www.sqlteam.com/item.asp?ItemID=2652Tara Kizer |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-12-22 : 00:57:33
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50648 |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-12-22 : 11:14:22
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=CSV,Splitting%20delimited%20lists,Best%20split%20functions |
|
|
|
|
|
|
comma separated values