SQL Server 2005 - How can I do a Reg Exp in T-SQL

Is there any w开发者_如何学Cay I can perform a Regular Expression search using T-SQL in SQL Server 2005 without having to load a .Net Assembly?

It seems that you can do it with VBScript, but it's not very pretty.

Unfortunately, the only way I know is by using a CLR udf as described in http://msdn.microsoft.com/en-us/magazine/cc163473.aspx

Dan Farino seems to have written an SP for SQL Server exactly for the purpose of using regex without having to install a .NET framework for CLR. Looks promising.