| Applies from Version: | WEBcnx 2024.1 | Applies to Version: |
Description
The ISNOTNULL function checks if a parameter is not equal to "Null". In short, it returns the opposite value to ISNULL.
Syntax
ISNOTNULL(value)
The ISNOTNULL function has the following argument:
- value Required. The value to check.
Usage
This function takes one parameter of any type
Returns
A Boolean. False if the parameter has a null value, true if not.
Remarks
- This is the same as calling MyExpressionValue.IsNotNull or NOT(MyExpressionValue.IsNull), but the advantage of using ISNOTNULL() is that it covers all parameter types, even those that do not support the .IsNull and .IsNotNull syntax.
Examples
Imagine we have a String field MyString
| Expression | Description | Result |
|---|---|---|
| ISNOTNULL("Hello") | Determines whether the string "Hello" is not null | True |
| ISNOTNULL(MyString) | Determines whether the MyString field is not null | True or False, depending on Task Values |