Skip to content
Advertisement

case statement is returning a 0 instead of empty string

I have the following case statement;

I would like it to return

But the output I am getting is;

I dont want the zeros, I would like the empty string.

Advertisement

Answer

You want to return a string, so you need to cast the else:

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement