How to make Regex work in SQL 2005?

I suspect you mean to use Regex.Match but that's just a guess.

In general I want to use the Regular Expression funtion in SQL 2005. For now I can say it's right, I want to use Regex.Match function. But in order to use it i have to first compile the code in Figure 1 from the article and then use create an assembly right? I'm not a .net developer so I don't know how to do that. I just want to know the steps as the article already had the code out there so I want to test it.

Can't help with that, sorry.

Thanks very much for the help!
I ran the create assembly statement below but got this message:
Msg 6501, Level 16, State 7, Line 2
CREATE ASSEMBLY failed because it could not open the physical file "C:\Temp\CLR\ClassLibrary1\bin\Release\ClassLibrary1.dll": 3(The system cannot find the path specified.).
-------------------------------------------------------------------------------------------------------------------------
CREATE ASSEMBLY MyRegexTest
FROM 'C:\Temp\CLR\ClassLibrary1\bin\Release\ClassLibrary1.dll'    
WITH PERMISSION_SET = EXTERNAL_ACCESS;
----------------------------------------------------------------------------------------------------------------
so where is the problem? Does the path have to be under Program Files\Microsoft SQL Server...?
Thanks again!

oK I figured it out the c drive is on my local and the sql server is a remote server. Anyway I was able to create the assembly and I'm testing the function...I'll see how it works. Thanks!

Well, when I create the function I got this message:
Msg 6505, Level 16, State 1, Procedure RegexMatch, Line 2
Could not find Type 'Microsoft.Samples.SqlServer.MyRegexTest' in assembly 'ClassLibrary1'.
--------------------------------------------------------------------------------------------------------------------------
CREATE FUNCTION [dbo].[RegexMatch] (@str nvarchar(4000))
RETURNS bigint
AS EXTERNAL NAME [MyRegexTest].[Microsoft.Samples.SqlServer.MyRegexTest].[RegexMatch];
GO

This is the .net code I compiled to dll:
-------------------------------------------------------------------------------------
public static partial class UserDefinedFunctions
{
    public static readonly RegexOptions Options =
        RegexOptions.IgnorePatternWhitespace |
        RegexOptions.Singleline;

    [SqlFunction]
    public static SqlBoolean RegexMatch(
        SqlChars input, SqlString pattern)
    {
        Regex regex = new Regex( pattern.Value, Options );
        return regex.IsMatch( new string( input.Value ) );
    }
}
-----------------------------------------------------------------------------
And I was trying to test the function by running this query see whether the input string matches the pattern specified.
select dbo.RegexMatch( N'123-45-6789', N'^\d{3}-\d{2}-\d{4}$' )

Thank you!

OK, OK, I figured it out:
CREATE FUNCTION [dbo].[RegexMatch] (@str nvarchar(4000), @pattern nvarchar(4000))
RETURNS bit
AS EXTERNAL NAME [MyRegexTest].[ClassLibrary1.UserDefinedFunctions].[RegexMatch];
GO

then the query below returns 1.
select dbo.RegexMatch( N'123-45-6789', N'^\d{3}-\d{2}-\d{4}$' )


Thanks a lot!

Excellent, now we all know how to do it! :)