Case Statement - End with a Blank Value

Question

Hi,

I have a Case Statement but to close it off, I have

else ' ' end as 'Variable_Name'

This then still outputs a 0 but I want it to be blank. Any idea how I can do this please?

Answer 1

Try casting the expressions that appear before else, for example:

 ... then cast(Co_Numeric as varchar(max)) else ' ' end as 'Variable_Name'

Sometimes you can use NULL instead of ' '.