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.