DB2里怎么实现T-SQL里的ISNULL()功能啊

DB2里怎么实现T-SQL里的ISNULL()功能啊  

coalesce()     方法和isnull()是一样的

select p.payId,p.payer,s.servName, coalesce(c.caseNumber,0) as caseNumber,d.deptName,c.caseStartDate,dic.dictValue,u.userName     from db2admin.T_PaymentInfo p left join db2admin.T_CaseBaseInfo c on c.caseId=p.payCaseId  left join db2admin.T_user u on u.userid=p.payPrintPerson left join db2admin.T_department d on d.deptid=p.paydeptid left join db2admin.T_dictionay dic on p.paystatus=dic.dicid  left join T_SERVICEITEM s on s.servid=c.caseServiceItemId left join db2admin.T_distict dis   on  dis.distid=d.distid   where  p.payDate >= '2008-06-01' and p.payDate <= '2008-06-15'  and p.payer='张三'