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 |
|
tchinedu
Yak Posting Veteran
71 Posts |
 Posted - 2005-11-30 : 16:23:03
|
| Hey Guys, I receieve a string in my stored procedure that I need to split based on a known separator.EX: @SQLstring = 'first day of Month | 1st of Dec 2006 | date of birth | last known Address | etc.this string could be any lenght.I basically need to split this string into individual strings using the | delimeter as indicator of individual string end point. How do I go about this |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-30 : 16:34:43
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Best+split+functionsKristen |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-01 : 03:17:07
|
That's the same one Maddy  |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-01 : 03:48:37
|
Well. I think there are more than one topic that discusses Split and thought you were referring someother  MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
String Split Problem