How can I use RLIKE MySQL function inside of SQL Server 2005?

Question

I need to run a RLIKE query on a database mmoved from MySQL to SQL Server 2005 however having problems replicating the "RLIKE" functionality that MySQL provides.

Does anyone have any ideas?

Cheers,

Chris

Answer 1

The only way I know of to do that is to add user defined CLR functions.

To begin with, here's an MSDN Magazine article, "Regular Expressions Make Pattern Matching And Data Extraction Easier"

The code for that article, which I've been using for a couple of years now, is here.