Casting question

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

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

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

  • 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)

  • good question on datatype conversion practices.


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

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