nvl
Returns the value of "expression1" if "expression1" is not NULL. If "expression1" is NULL, then returns the value of "expression2".
Syntax
nvl ( expression1 , expression2 )Example
nvl ( [Unit sale price] , 0 )Result
Returns the unit sale price, or returns 0 if the unit sale price is NULL.