COALESCE
The COALESCE function returns the first non-NA expression in a list of expressions, or NA when all of the expressions evaluate to NA.
Return Value
Data type of the first argument.
Syntax
COALESCE (expr [, expr]...)
Arguments
- expr
-
An expression.