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,
4 kB (4096 bytes)