The standard COALESCE case expression is supported, generating SQL of the form COALESCE (expression, …expression). It must be supplied at least two arguments. The entire COALESCE expression will automatically be enclosed in parentheses if it is not part of an expression and not already enclosed in parentheses. When dragging a Coalesce into a variable, the following tree element is created.
There are no special properties for the Coalesce function.