Add built-in support for regular expressions in T-SQL - by Steven Twitchell - MSFT

Status : 


Sign in
to vote
ID 296631 Comments
Status Active Workarounds
Type Suggestion Repros 2
Opened 9/4/2007 11:17:42 AM
Duplicates 289017 Access Restriction Public
Primary Feedback Item 261342


LIKE is very limited in what it can differentiate.  The CLR has much more robust handling for regular expressions, but it's hard to get to from T-SQL.

Could we add built-in functionality in T-SQL to do regular expression pattern matching?
Sign in to post a comment.
Posted by Microsoft on 3/25/2010 at 11:10 AM
Resolved as duplicate.

Posted by Microsoft on 3/24/2010 at 3:59 PM
Resolved as duplicate.

Posted by Microsoft on 3/24/2010 at 2:54 PM
I have resolved this request as duplicate of feedback item below:

Umachandar, SQL Programmability Team
Posted by Microsoft on 10/15/2007 at 8:43 AM
This is a request we've heard a lot, and it's of obvious value. I can't promise when we'll get to it---it's doubtful for this release---but this is certainly on our radar.

Posted by Mark Yudkin on 9/5/2007 at 7:05 AM
Like Steve, I would also like to stress that any implementation should be as per ANSI (SIMILAR predicate). The CLR functionality is not a relevant design consideration.
Posted by Steve Kass on 9/4/2007 at 12:29 PM
If this is considered for a future version of SQL Server, please implement it according to the ISO SQL standard. In other words, implement the SQL Standard <similar predicate>, which provides regular expression support through the operator [NOT] SIMILAR TO, which in the standard remains separate from LIKE.