Finding the Substring

Question

Finding the Substring

Steve Jones - SSC Editor

SSC Guru

Points: 737899
More actions
March 26, 2019 at 10:50 pm

#2031615

Comments posted to this topic are about the item Finding the Substring

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

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

Stewart "Arturius" Campbell SSC Guru Points: 72710 More actions · Answer 1

Really interesting question, thanks Steve

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

HappyGeek SSCoach Points: 18729 More actions · Answer 2

Good question, but a bit confused and had to look up how a US number is formatted, the answer seems to suggest a further digit(?), but thanks Steve

...

Wolfram Kraus SSCrazy Points: 2774 More actions · Answer 3

Am I blind? What's the difference between answer 2 and 3?
BTW: Nice question. I always have to look up the substring syntax in any programming language. Even if I did it just minutes ago.

Arno.Hubert.Janssen SSCrazy Points: 2756 More actions · Answer 4

Wolfram Kraus - Wednesday, March 27, 2019 1:46 AM
Am I blind? What's the difference between answer 2 and 3?
BTW: Nice question. I always have to look up the substring syntax in any programming language. Even if I did it just minutes ago.

The 2nd or 3rd option probably should have been > substring(phone,6,14)...?

LadyRuna SSCrazy Points: 2421 More actions · Answer 5

Fun question... of course, now I've got a certain song stuck in my head. ....thanks for the earworm, @steve-2

Fred_unique SSC Enthusiast Points: 156 More actions · Answer 6

HappyGeek - Wednesday, March 27, 2019 12:21 AM
Good question, but a bit confused and had to look up how a US number is formatted, the answer seems to suggest a further digit(?), but thanks Steve

In the US, a 1 or 0 is often put before the area code to indicate long distance or operator assistance, like 1 (555) ...

Steve Jones - SSC Editor SSC Guru Points: 737899 More actions · Answer 7

Arno.Hubert.Janssen - Wednesday, March 27, 2019 6:27 AM
Wolfram Kraus - Wednesday, March 27, 2019 1:46 AM
Am I blind? What's the difference between answer 2 and 3?
BTW: Nice question. I always have to look up the substring syntax in any programming language. Even if I did it just minutes ago.
The 2nd or 3rd option probably should have been > substring(phone,6,14)...?

Thanks, answer changed (Wrong answer)

Finding the Substring

Cookies on SQLServerCentral