RegEx for SQL Server .dll
This is a DLL I created to allow RegEx to be used via UDF in SQL Server. It will allow you to generate a UDF called 'fRegExMatcher' that return a bit value based on the field/variable and RegEx pattern you provide as argument to the function. You'll need to download the file, and issue the following command in your instance: CREATE ASSEMBLY SQLTools FROM '<path>\SQLDataImportTools.dll' CREATE FUNCTION fRegExMatcher ( @Pattern nvarchar(max), @MatchString nvarchar(max) ) RETURNS BIT AS EXTERNAL NAME SQLTools.UserDefinedFunctions.RegExIsMatch
SQLDataImportTools.dll
—
application/x-msdos-program,
4Kb

