ISNULLOREMPTY
Syntax
ISNULLOREMPTY (expression)
Description
ISNULLOREMPTY checks to see if the value in expression is Null or empty and returns True or False based on the result.
Note: In some cases you may need to check for whitespace instead of Null or empty. Whitespace refers to space, tabs, or certain Unicode characters identified as blanks. See ISNULLORWHITESPACE.
Arguments
| expression | Any valid expression, a Null value, or an empty string, that is, " " |
Returns
If expression is Null or empty, returns a Boolean True.
If expression is not Null or empty, returns a Boolean False.
Examples
The following formula checks to see if the value for MyEntity.LastName is Null or empty, and if so, provides a default value:
IF(ISNULLOREMPTY(MyEntity.LastName), "MissingLastName", MyEntity.LastName)
Returns:
— The value in LastName.
— "MissingLastName", if the value in LastName is Null or empty.