I am trying to use coalesce function in DB2.
Here is my syntax..
select coalesce (("rel".ID_NUM), 0)
from table x

If the value returned is null I want to show "None" or "Empty" in the result instead of default "[Null]" or 0 (according the above code).

Can someone please help in this regard.

Thank you.