Click here to Skip to main content
15,867,704 members
Articles / Database Development / SQL Server

SQL User Defined Function to Parse a Delimited String

Rate me:
Please Sign up or sign in to vote.
4.85/5 (25 votes)
5 Apr 2016CPOL2 min read 276.4K   49  
SQL Function to parse a delimited string and return it as a table. Handles multi-character delimiters and returns the results as a table.

Views

Daily Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Web Developer Clayton Groom, LLC
United States United States
I am a database design consultant with over 20 years experience in consulting.

My primary focus is designing and bulding data driven, highly automated OLTP and datatwarehouse applications that leverage the Microsoft SQL Server platform. I am skilled in SQL Server Analysis Services (MDS and Tabular), MDX, DAX, and all the related technologies. I am experienced with SharePoint Business Intelligence and dashboard capabilities, including installation, configuration, and Kerberos authentication set up.

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

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

Comments and Discussions