Thanks Visakh this is what i tried
SELECT DISTINCT DIVNAME, COALESCE(DIVNAME, '(null)','UNKNOWN') AS Col1DescriptionFROM TBLORDER BY DIVNAME
but am still getting (null) instead of unknown
No comments:
Post a Comment