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.

Eric Melcher

My feedback

  1. 6 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

    0 comments  ·  Azure Resource Manager  ·  Flag idea as inappropriate…  ·  Admin →
    Eric Melcher shared this idea  · 
  2. 17 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

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

    Upvotes: 419

    <=-=Mar 8 2007 3:20AM=-=>

    I agree with the functionality request, but not the suggested approach of enhancing the LIKE, PATINDEX or adding a table function.

    This functionality should be implemented by supporting the SQL99 SIMILAR predicate (ISO 9075 feature T141, ISO 9075-2-1999 section 8.6).

    <=-=Mar 21 2007 1:23PM=-=>

    I echo the wish to not overload LIKE or PATINDEX. Personally I don’t like SIMILAR either, though. How about a REGEX function with REGEX somewhere in the name?

    <=-=Aug 20 2007 10:21PM=-=>

    Hello,

    First of all i would like to thank all of you for sending your feedback to us. We are definitely going to consider adding this capability in the query language in a future release. However, until then have you considered using CLR integration for this purpose. .NET has the capability and it is very simple to use .NET to add this capability…

    Eric Melcher supported this idea  · 
  3. 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
    Eric Melcher commented  · 

    Fully agree with Aaron. There is no way to achieve this in Azure SQL now that CLR is no longer an option.

    Eric Melcher supported this idea  · 
    An error occurred while saving the comment
    Eric Melcher commented  · 

    In legacy SQL environments, this could be done using a CLR. However, with Azure SQL, this is no longer an option. There is no feasible way to achieve REGEX in Azure SQL. This needs to be addressed by adding REGEX capabilities natively into T-SQL.

Feedback and Knowledge Base