REGEX

  • steve.jacobs

    SSCommitted

    Points: 1830

    Comments posted to this topic are about the item REGEX

  • Koen Verbeeck

    SSC Guru

    Points: 258955

    Great question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Bangla

    Hall of Fame

    Points: 3137

    Nice one....

  • Carlo Romagnano

    SSC-Insane

    Points: 21810

    That's true:

    In SQL Server, regular expressions really are poor.

    😎

  • This was removed by the editor as SPAM

  • Mighty

    SSCrazy Eights

    Points: 8468

    As far as I know SQL Server can only handle REGEX via the CLR, so .NET.

    The queries as shown here were not using REGEX.

  • alex.d.garland

    Right there with Babe

    Points: 749

    Mighty (11/14/2013)


    As far as I know SQL Server can only handle REGEX via the CLR, so .NET.

    The queries as shown here were not using REGEX.

    +1

    This was a really good question to test understanding of SQL string pattern matching (thanks Steve!) but I don't believe it strictly counts as Regex.

  • TomThomson

    SSC Guru

    Points: 104772

    alex.d.garland (11/14/2013)


    Mighty (11/14/2013)


    As far as I know SQL Server can only handle REGEX via the CLR, so .NET.

    The queries as shown here were not using REGEX.

    +1

    This was a really good question to test understanding of SQL string pattern matching (thanks Steve!) but I don't believe it strictly counts as Regex.

    Well, surely some of it is the nearest thing T-SQL has to REGEX? Maybe some of it really is too unlike REGEX to be thought of that way, but definitely some of it isn't.

    Tom

  • Thomas Abraham

    SSChampion

    Points: 10761

    Excellent question. Simply explained and good references. Thanks!

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • Dana Medley

    SSCertifiable

    Points: 6764

    Stewart "Arturius" Campbell (11/14/2013)


    Agree with the point regarding regex in T-SQL. .Net is definitely much more efficient in this regard...

    +1 Thanks for the great question.



    Everything is awesome!

  • Revenant

    SSC-Forever

    Points: 42467

    Simple question but lots of mental work. Thanks, Steve!

  • webrunner

    One Orange Chip

    Points: 29947

    Cool question, thanks.

    - webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and says Can I join you?
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • Christian Buettner-167247

    SSChampion

    Points: 13729

    Mighty (11/14/2013)


    As far as I know SQL Server can only handle REGEX via the CLR, so .NET.

    The queries as shown here were not using REGEX.

    What do you mean with that? As far as I understand, the examples did use regular expressions - a very limited form though.

    Best Regards,

    Chris Büttner

  • sqlnaive

    SSCoach

    Points: 17435

    Good question Steve. It gave me little hard time. 🙂

  • jfgoude

    SSCrazy

    Points: 2586

    good question !

    eliminating possibilities one by one give a good guess

    thanks

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply