Numbers to Letters

Question

Numbers to Letters

Steve Jones - SSC Editor

SSC Guru

Points: 736494
More actions
April 19, 2021 at 12:00 am

#3865991

Comments posted to this topic are about the item Numbers to Letters

Viewing 4 posts - 1 through 3 (of 3 total)

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

Ken Hiatt SSC-Addicted Points: 469 More actions · Answer 1

I chose A and B which just goes to show that you should never take a quiz right after you wake up. “Ascii code 65 means A, peace of cake, who could get that wrong?” The person not awake enough to comprehend the actual question (me). 🙂

But it does seem like an implicit conversion in this case, could be problematic. After all, you’re sending a numeric parameter to a function designed to accept a character. Seems to me there is a problem in the code that should be fixed, but instead of an “invalid parameter” error, Microsoft “helps” out with an implicit conversion allowing the program to continue, giving you the wrong answer, and making it harder to find the problem.

Ken

Steve Jones - SSC Editor SSC Guru Points: 736494 More actions · Answer 2

I constantly think ASCII gives me A as well.

Not sure about this being a problem, after all a number is valid. More, I think they built the wrong function names from the beginning.

tripleAxe SSCertifiable Points: 5706 More actions · Answer 3

Doh!

My brain "auto-translated" it to CHAR instead of ASCII, guess that is what it was expecting to see with the numerical values .e.g SELECT CHAR(65),CHAR(66)

🙂