Click here to Skip to main content
12,249,279 members (30,308 online)
Click here to Skip to main content
Articles » Database » Database » SQL Server » Revisions

Stats

197.7K views
1 download
47 bookmarked
Posted

SQL User Defined Function to Parse a Delimited String

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

Revisions


  

Compare Revision Minor Date Status Editor
3 - publicly available Yes 5-Apr-16 21:37 Available SQLMonger
The article has been approved
2 No 5-Apr-16 18:15 Pending SQLMonger
I added the ability to parse and convert date values from a string as well as a second version of the function that uses the SQL Server XML functions to parse values. The performance of the XML approa
1 No 10-Aug-04 0:00 Available Jonathan Russell

License

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

Share

About the Author

SQLMonger
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.

You may also be interested in...

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.160426.1 | Last Updated 5 Apr 2016
Article Copyright 2004 by SQLMonger
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid