SUBSTRING

  • Comments posted to this topic are about the item SUBSTRING

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • Thanks for that QOTD Drew.

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

  • 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

  • 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”

  • I got a blank! result. 

  • 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.

  • Oh Thanks.  Missed the trick.

  • nice question to recall the simple function....

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

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

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