Page tree
Skip to end of metadata
Go to start of metadata

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

Column1Column2COALESCE(#Column1;#Column2)COALESCE(#Column2;#Column1)
155155
2<null>22
<null>575757
458458
  • No labels