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] , [Unit price] )Result
Returns the unit sale price, or returns the unit price if the unit sale price is NULL.