RE: Embedded Sql problem

["Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>]

This is from the SQL Reference book:

IFNULL

IFNULL ( expression , expression ) 

The IFNULL function is identical to the COALESCE scalar function with two
arguments. For more information, see "COALESCE" on page 152.
Example
When selecting the employee number (EMPNO) and salary (SALARY) from all the
rows in the EMPLOYEE table, if the salary is missing (that is, null), then
return a value of zero.
SELECT EMPNO, IFNULL(SALARY,0)
FROM EMPLOYEE 

Elvis