Regular Expression Support

microsoft.public.sqlserver.programming

17 Feb 2006 7:21 AM

Jeff S

Is there any Reg Ex support in any recent version of SQL Server; like for
use with check constraints?

-Thanks

17 Feb 2006 7:34 AM

SriSamp

You can create user-defined function in a CLR language like C#. In this you
can use the RegEx libraries and then expose that CLR function to SQL Server
2005. In fact there is an example of this in the books online.

--
HTH,
SriSamp
Email: sris***@gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp

Show quote

"Jeff S" <A@B.COM> wrote in message
news:uwGACL5MGHA.2916@tk2msftngp13.phx.gbl...
> Is there any Reg Ex support in any recent version of SQL Server; like for
> use with check constraints?
>
> -Thanks
>