Casting question

Question

Viewing 5 posts - 31 through 34 (of 34 total)

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

For some reason I just didn't catch the CHAR(3) in the question. Even if I had, I would still have picked '0'.

baabhu SSCertifiable Points: 6205 More actions · Answer 2

Neither I don't understand for the reason for char(3).

sqlnaive SSCoach Points: 17437 More actions · Answer 3

Seems pretty simple question to me. An easy point. 🙂

Arno Kwetters Hall of Fame Points: 3704 More actions · Answer 4

Why is the type char(3) ?

If I use one of the below selects, then it is all the same !

select convert (char(3),11/9)

select convert (int,11/9)

select convert(float ,11/9)

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 5

good question on datatype conversion practices.

Thanks.