SQL delimited string parsing…

One day, while working, I found a way to parse a string that is made up of a character-delimited set of values. I’ve tested it using comma’s, vertical pipes, colons, spaces, etc. I did modify the original code I found to make it a little simpler. I don’t remember where I found it at several months ago, or I’d post a source link. Here’s what I have. Maybe it will help someone out there, too.

Here’s the SQL itself:

Parsing SQL

And here’s the result set:

Parsing Results

Jeff Kohnz

I am a Christian man with a beautiful wife and 4 awesome kids. I have been a mechanic (almost 14 years), a software developer since 2008, a visual artist (most of my life), and am constantly keeping myself busy doing something.


  1. Thanks. Very nice post. Your web site is very beautiful.

Leave a Reply

Your email address will not be published. Required fields are marked *