NOT_NULL_OR_EMPTY

Description

The not_null_or_empty function is used to determine whether the given value is not NULL and not empty. If the input value is neither NULL nor empty, it returns true; otherwise, it returns false.

Syntax

NOT_NULL_OR_EMPTY (<str>)

Parameters

• <str>: String type, the string to be checked for NULL or empty.

Return Value

Returns false if the string is an empty string or NULL; otherwise, returns true.

Examples

1. Example 1

   select not_null_or_empty(null), not_null_or_empty("");, not_null_or_empty(" ");

   +-------------------------+-----------------------+------------------------+
   | not_null_or_empty(null) | not_null_or_empty("") | not_null_or_empty(" ") |
   +-------------------------+-----------------------+------------------------+
   |                       0 |                     0 |                      1 |
   +-------------------------+-----------------------+------------------------+