Case select on tiny int but return null as blank char not zero 1

[1DMF]

Hi,

I seem unable to get the syntax right to use a case select on a tinyint column that returns blank if it is null.

I have

CAST(
Case When
(Final_Rating IS NULL)
Then ''
Else Final_Rating
End AS Char(1))

But the returned result for those that are NULL show ZERO not blank?

How do I return blank for a tinyint column that is NULL?

Thanks,

Craig.

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Free Dance Music Downloads

 

[drlex]

Craig,
The problem you're having is that the conditional is being resolved by the bit state of the non-NULL result. Move the "Cast" to solve:

Case When
(Final_Rating IS NULL)
Then ''
Else CAST(Final_Rating
AS Char(1)) 
End

Now each result is a string.
HTH,
lex


soi là, soi carré

 

[1DMF]

Now each result is a string.

Ah got ya!

Many thanks
1DMF

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Free Dance Music Downloads