| Applies from Version: | WEBcnx 2024.1 | Applies to Version: |
Description
The ISNULL function checks if its parameter is equal to "Null" - i.e. an empty value.
Syntax
ISNULL(value)
The ISNULL function has the following argument:
- value Required. The value to check.
Returns
A Boolean. True if the parameter has a null value, false if not.
Remarks
- This is the same as calling MyExpressionValue.IsNull, but the advantage of using ISNULL is that it covers all parameter types, even those that do not support the .IsNull syntax.
Examples
Imagine we have a String field MyString
| Expression | Description | Result |
|---|---|---|
| ISNULL("Hello") | Determines whether the string "Hello" is null | False |
| ISNULL(MyString) | Determines whether the MyString field is null | True or False, depending on Task Values |