• Thank you for this example.

    If you do much data cleansing or string manipulation, keep in mind that you can implement regular expression functionality in SQL Server 2005 and above. It's easier than I thought it would be, assuming your DBA allows you to enable CLR integration.

    This article lays it out very well:

    http://justgeeks.blogspot.com/2008/08/adding-regular-expressions-regex-to-sql.html