If you can use CLRs you could look at mdq.regexmatches. See this thread.

-- Alan Burstein

Read this article for best practices on asking questions.Need to split a string? Try this (Jeff Moden)Need a pattern-based string spitter? Try this (Dwain Camps)

"I can't stress enough the importance of switching from a 'sequential files' mindset to 'set-based' thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code. " -- Itzek Ben-Gan 2001