SUBSTRING

Question

Post reply

SUBSTRING

drew.allen

SSC Guru

Points: 76985
More actions
March 8, 2018 at 12:05 am

#329542

Comments posted to this topic are about the item SUBSTRING
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

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

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

paul s-306273 SSChampion Points: 10730 More actions · Answer 1

paul s-306273

SSChampion

Points: 10730

March 8, 2018 at 2:43 am

#1982350

Thanks for that QOTD Drew.

George Vobr SSCrazy Eights Points: 9996 More actions · Answer 2

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

webrunner SSC-Dedicated Points: 31862 More actions · Answer 3

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: 72624 More actions · Answer 4

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”