Functions for Handling Null Values¶

• ISNOTNULL: The function receives one argument of any type and returns “true” if the value is not null, and “false” otherwise.

• ISNULL: The function receives one argument of any type and returns “true” if the value is null, and “false” otherwise.

• COALESCE: The function receives a list or values of the same type and returns the first one not null.