Introduce more regular expressions functions to T-SQL
Regular expressions need to be more fully implemented in the T-SQL engine. For instance Oracle's REGEXP_SUBSTR would be nice so I could look for a string like b%e in abcdefg, replace it to get a[new string]fg.
Upvotes: 12<=-=Oct 19 2007 8:18AM=-=>
This is indeed a good suggestion—-so good we’ve gotten it a few times. :) I’m resolving this as a duplicate of Connect item 296631.
I have resolved this request as duplicate of feedback item below:
Umachandar, SQL Programmability Team