If you are using PLSQL check out the function 'NVL'.