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?

4 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    0 comments

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

      Feedback and Knowledge Base