SQL Server doesn’t provide native support for Regular Expressions. But in SQL Server 2005 and above, its support for hosting Common Language Runtime (CLR) can remedy this. Here is a very good article talking about how to implement it in SQL Server 2005.
Regular Expressions Make Pattern Matching And Data Extraction Easier
BTW, I found a very cool FREE tool for developing Regular Expressions called Expresso.