ISNULL
Syntax
ISNULL (expression)
Description
ISNULL checks to see if the value in expression is Null and returns True or False based on the result.
Arguments
| expression | Any valid expression or a Null value. |
Returns
If expression is Null, returns a Boolean True.
If expression is not Null, returns a Boolean False.
Remarks
The function IFNULLUSE can also be used to create the following example.
Examples
The following formula checks to see if the value for MyEntity.LastName is Null, and if so, provides a default value:
IF(ISNULL(MyEntity.LastName), "MissingLastName", MyEntity.LastName)
Returns:
— The value in LastName.
— "MissingLastName", if the value in LastName is Null.