This is absolutely the best approach I've seen anywhere for string parsing. It uses a set-based approach instead of parsing through the data set row by row and then through each string character by character. The performance of this function will surprise you.

Be forewarned that once you use this approach, you'll never want to go back. 😎