Personal tools
You are here: Home Database SQL Server RegEx for SQL Server .dll

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

Document Actions
« July 2010 »
July
MoTuWeThFrSaSu
1234
567891011
12131415161718
19202122232425
262728293031