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

问题:

Is there any way I can perform a Regular Expression search using T-SQL in SQL Server 2005 without having to load a .Net Assembly?

回答1:

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

回答2:

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

回答3:

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.