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 AMI 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