It is a shame that TSQL lacks the CONNECT BY clause that is available with Oracle. All these complex solutions could be eliminated for many classes of row-joining queries.

Maybe I misread your last comment. I have to be able to do a regex for both testing and value extraction WITHIN TSQL because I need to create an output...

Yep. If you could have manipulated the collection returned by the VBScript.RegExp EXECUTE method, the code might have been a little shorter. You didn't pursue the vbs method further.

I might...

I have this very same question. Have you learned anything more on this? I am starting to think this is not solvable using a direct call to the VBScript.regexp from...