Figured by now SQL 2008 R2 should have regular expressions, and it doesn’t quite, but it can. Here’s two of the ways you might do this:
1. Use MDS … it’s an add in for SQL 2008 R2. Assuming you are running x64, , have IIS, .net 3.5 or later etc., you can install MasterDataServices (hidden in plain site on the install DVD or ISO) .. look in the directory:
this MSDN link will tell you more:
but for a great step by run down of the step install, that’s simple you might also see:
you can add the MDS functions into another database using this:
more info on using the MDS functions themselves:
2. Add (or create) your own CLR implementation of Regex functions, for example:
haven’t done this one yet, more later ..