Is there an SQL equivilant to VB Split function?

[roblasch]

I have a field that has multiple entries seperated by comma's (ex. His, Art, Anth). I am trying to extract every distinct word. The Visual Basic function Split works great for this, but I need to do it in SQL. Is there any way to do this without complicated coding, ie finding the position of each comma and working forward and backwords to extract the words. Thanks

 

[roblasch]

Should I post this in the ASP forum?

 

[tlbroadbent]

If you have SQL 2000, check out the UDF, fn_Split() at the following link.

http://msdn.microsoft.com/library/en-us/dnsqlmag01/html/TreatYourself.asp

Otherwise, check SWYNK.COM for some parsing scripts.

http://www.swynk.com/sqlscripts/misc7.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[shrisaianandhi]

hai roblash,
you could try the patindex(),it would help you