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

Copy

isNotNull(expression)

Arguments

expression

The expression to be evaluated as null or not. It can be a field name like address1 or a call to another function that outputs a string.

Return type

Boolean

Example

The following example evaluates the sales_amount field for null values.

Copy

isNotNull(salesAmount)

The following are the given field values.

Copy

20.13
(null)
57.54

For these field values, the following values are returned.

Copy

true
false
true