isNotNull
isNotNull evaluates an expression to see if it is not null. If the
expression is not null, isNotNull returns true, and otherwise it returns
false.
Syntax
isNotNull(expression)
Arguments
- expression
-
The expression to be evaluated as null or not. It can be a field name like
address1or a call to another function that outputs a string.
Return type
Boolean
Example
The following example evaluates the sales_amount field for null values.
isNotNull(salesAmount)
The following are the given field values.
20.13 (null) 57.54
For these field values, the following values are returned.
true false true