Description |
|
Syntax | COALESCE( |
Output | text |
Variables
option1, option2, ...
: Multiple options to evaluate and return the first non-null value.
Example
COALESCE(`Option 1`, `Option 2`)
Option 1 | Option 2 | COALESCE |
5 | NULL | 5 |
NULL | "Hello" | "Hello" |
NULL | NULL | NULL |