coalesce
Returns the first non-null argument (or null if all arguments are null). Requires two or more arguments in "expression_list".
Syntax
coalesce ( expression_list )Example
coalesce ( [Unit price], [Unit sale price] )Result
Returns the unit price, or the unit sale price if the unit price is null.