SQL User Defined Function to Parse a Delimited String

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

No alternatives have been posted.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

About the Author

Claytong

Web Developer

United States

Member

I have been a database design consultant for the past 10 years. My primary focus is designing and bulding data driven, highly automated OLTP and datatwarehouse applications that leverage the Microsoft SQL Server platform.

I have worked with SQL Server since version 4.12 and have experience with Oracle, Sybase and DB/2 as well.

I would term myself as a Data architect and programmer DBA, with a good dose of system architect and troubleshooter thrown in.

SQL Function to parse a delimited string and return it as a table. Handles multi-character delimiters and returns the results as a table.

Type	Article
Licence
First Posted	9 Aug 2004
Views	139,456
Bookmarked	35 times

Win2KSQL2000C++SQL
Visual-StudioDBADev, +

		9,892,249 members (30,111 online) Visit CodeProject.TV Discuss CodeProject.TV Sign in Email Password Forgot your password? Sign in using