How to brake a string into smaller substrings inside a stored proc...

[Plato2]

I want to write a stored procedure that recieves 2 param. and both are char. And one of the strings has words separeted by commas. So how can I brake this string into words.
Thanks in advance

 

[tlbroadbent]

Which database are you using? Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/programmer.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[Plato2]

I'm using sql server 2000

 

[dnoeth]

One solution by Itzik Ben-Gan:

http://www.tsqlsolutions.com/Articles/Index.cfm?ArticleID=25678

You'll just have to register to access that information ;-)

Dieter

 

[tlbroadbent]

You should post questions regarding MS SQL Server in forum183. That is the SQL Serer forum. If you do a keyword search in the SQL Server forum for "parse" or "delimited string". If you use SQL 2000, there is downloadable function, fn_split that is useful for parsing.

See thread183-325653 and thread183-292139. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/programmer.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.