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. 🙂
Hall of Fame
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)