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:
And here’s the result set: