Regular Expressions in SQL Server servers?

sql-server regex sql-server-2005 sql-server-2008 sql-server-2000
bovium picture bovium · Nov 6, 2008 · Viewed 23.1k times · Source

Is it possible to make efficient queries that use the complete regular expression feature set.

If not Microsoft really should consider that feature.

Answer

Tomalak picture Tomalak · Nov 6, 2008

For SQL Server 2000 (and any other 32 bit edition of SQL Server), there is xp_pcre, which introduces Perl compatible regular expressions as a set of extended stored procedures. I've used it, it works.

The more recent versions give you direct access to the .NET integrated regular expressions (this link seems to be dead, here is another one: MSDN: How to: Work with CLR Database Objects).

Related questions

Using RegEx in SQL Server

I'm looking how to replace/encode text using RegEx based on RegEx settings/params below: RegEx.IgnoreCase = True RegEx.Global = True RegEx.Pattern = "[^a-z\d\s.]+" I have seen some examples on RegEx, but confused as to how to apply …

Read More
SQL Server Regular expressions in T-SQL

Is there any regular expression library written in T-SQL (no CLR, no extended SP, pure T-SQL) for SQL Server, and that should work with shared hosting? Edit: Thanks, I know about PATINDEX, LIKE, xp_ sps and CLR solutions I also …

Read More
Regular expressions inside SQL Server

I have stored values in my database that look like 5XXXXXX, where X can be any digit. In other words, I need to match incoming SQL query strings like 5349878. Does anyone have an idea how to do it? I have …

Read More