Get Multiple values from a field

[cvkorke]

Hi all

I have a SQL server field which has multiple values delimited by a newline(chr(13)) character. I would like to split the field into multiple fields. How is it possible to do it ? Is there an function which would help me do this ?

E.G I have SQL Server column named Brand

Field Name Values
Brand BrandX(delimiter)BrandY(delimiter(BrandZ)

(delimiter) is a newline character Chr(13)

I want to split the above values so that I get
Brand1 BrandX
Brand2 BrandY
Brand3 BrandZ

I know there will be a maximum of 10 brands.

Please Help

regards

Chetan

 

[tlbroadbent]

If you use SQL 2000, you can create a UDF to parse delimited strings. You can even download such a UDF.

Treat Yourself to Fn_Split()

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

There are several parse scripts you can download from SWYNK.COM. These are usable in SQL 7 and higher.

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

Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)

http://www.saltlake2002.com