Friday, June 27, 2014

How to include NULL in multi value parameters

Thanks Visakh this is what i tried


SELECT DISTINCT DIVNAME, COALESCE(DIVNAME, '(null)','UNKNOWN') AS Col1Description

FROM TBLORDER BY DIVNAME


but am still getting (null) instead of unknown



No comments:

Post a Comment