Regular expressions in MS SQL Server 2005/2008.

ou can use all .Net Framework Regular Expressions via MS Server CLR Integration. Microsoft recommends to use CLR Integration in scenarios where CLR-based programming can complement the expressive power of the T-SQL query language