Thread: Using coalesce in DB2
03-03-04, 20:51 #1Registered User
- Join Date
- Mar 2004
Unanswered: Using coalesce in DB2
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.