Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

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.

3 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AdminMicrosoft SQL Server (Product Manager, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 12

    <=-=Oct 19 2007 8:18AM=-=>

    Hello,

    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.

    Cheers,
    -Isaac

    <=-=Mar 26 2010 10:55AM=-=>

    Hi,
    I have resolved this request as duplicate of feedback item below:

    https://connect.microsoft.com/SQLServer/feedback/details/261342/regex-functionality-in-pattern-matching?wa=wsignin1.0


    Umachandar, SQL Programmability Team

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base