Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

Aaron Abdis

My feedback

  1. 87 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 54

    <=-=Sep 4 2007 12:29PM=-=>

    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 , which provides regular expression support through the operator [NOT] SIMILAR TO, which in the standard remains separate from LIKE.

    <=-=Sep 5 2007 7:05AM=-=>

    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.

    <=-=Oct 15 2007 8:43AM=-=>

    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.

    Cheers,
    -Isaac

    <=-=Mar 24 2010 2:54PM=-=>

    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

    <=-=Mar 24 2010…
    An error occurred while saving the comment
    Aaron Abdis commented  · 

    It was possible to get this function with CLR, but we have more and more of our clients moving to cloud-hosted SQL Server instances, such as AWS, where they simply do not even have the ability to enable CLR. So CLR implementations are becoming less and less plausible.

    As such, it is becoming more and more necessary for this to be implemented in SQL Server itself, without the need for CLR.

    Pretty please, with whipped cream... and sprinkles and a cherry on top?

    Aaron Abdis supported this idea  · 
  2. 5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  2 comments  ·  SQL Server » Other  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Aaron Abdis commented  · 

    YES! Please. This is one of the (Very) few things I miss form the ORACLE world. It makes code VASTLY more maintainable, and is far superior to UDTs, since once a UDT is used, you can't alter it without removing all the uses first.

    Aaron Abdis supported this idea  · 

Feedback and Knowledge Base