SUBSTRING

  • drew.allen

    SSC Guru

    Points: 76739

    Comments posted to this topic are about the item SUBSTRING

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • paul s-306273

    SSChampion

    Points: 10615

    Thanks for that QOTD Drew.

  • George Vobr

    SSCrazy Eights

    Points: 9216

    An unexpectedly interesting question about such a simple function, well done, thanks Drew.🙂

  • webrunner

    SSC-Dedicated

    Points: 30300

    Thanks for this question. I got it wrong so need to study more.

    - webrunner

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

  • Stewart "Arturius" Campbell

    SSC Guru

    Points: 71852

    I would have expected an error, but the error i expected was not in the list of possible answers (given that SQL Server sting functions are 1-based)
    so had to dig in and learned something interesting in the process, thanks Drew

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • g.maxfield

    Default port

    Points: 1471

    I got a blank! result. 

  • thisisfutile

    Hall of Fame

    Points: 3497

    g.maxfield - Friday, March 9, 2018 3:30 AM

    I got a blank! result. 

    This is what '' two apostrophes with nothing between them means ... nothing.  The result was nothing not to be confused with NULL.

    Ironically, when I click your screenshot, my screen shows a blank result (no screenshot) in both Edge and Chrome browsers.

  • g.maxfield

    Default port

    Points: 1471

    Oh Thanks.  Missed the trick.

  • manik_anu

    SSCrazy

    Points: 2367

    nice question to recall the simple function....

    Manik
    You cannot get to the top by sitting on your bottom.

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

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