The IFNULL function returns the value of the first non-null expression.
The IFNULL function is identical to the COALESCE scalar function with two arguments. For more information, see COALESCE.
SELECT EMPNO, IFNULL(SALARY,0) FROM EMPLOYEE
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.