COALESCE
Syntax
COALESCE(<any>;..)
Description
Returns the first non-null argument value for non-string values. It returns the first non-empty argument value for strings. COALESCE is a commonly used SQL function.
Examples
| Column1 | Column2 | COALESCE(#Column1;#Column2) | COALESCE(#Column2;#Column1) |
|---|---|---|---|
| 1 | 55 | 1 | 55 |
| 2 | <null> | 2 | 2 |
| <null> | 57 | 57 | 57 |
| 4 | 58 | 4 | 58 |