Hi,

I too added two functions for regular expressions. One to test and return a 0 or 1. And one to return the matching string. I tried to minimize the amount of work in the CLR and only use the functions when I really need them.

http://www.sqllion.com/2010/12/pattern-matching-regex-in-t-sql/

and

http://blogs.msdn.com/b/sqlclr/archive/2005/06/29/regex.aspx

I have added these to all my servers in a separate database so that I can call the same function from each of the servers.

Thanks,

Peter