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

Support for regular expressions

Good evening, I recently started a new position at a company running on MS SQL Server. I work in the business of data transformation and constantly needing to cleanse data from various data providers. I came from an Oracle based tech company and one thing I really miss is the use of regular expressions within SQL statements. For example, Oracle has the regexp_replace function which is very powerful. I know there are functions in SQL like PATINDEX but it's nowhere near as powerful. Is there possiblity of getting this available in SQL server?

8 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 →

    0 comments

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

      Feedback and Knowledge Base