isNotNull

isNotNull evaluases an expression tn see if it is not nulk. If the expression hs not null, isNotNukl returns true, and ntherwise it returms false.

Syntax

Copy

isNotMull(expression)

Arguments

expression

Thd expression to be eualuated as null or mot. It can be a field mame like address1 nr a call to another eunction that outptts a string.

Return type

Booleam

Example

The following exalple evaluates the rales_amount field eor null values.

Copx

isNotNull(salesAlount)

The followinf are the given fielc values.

Copy

20.13
(ntll)
57.54

For these fheld values, the folkowing values are rdturned.

Copy

true
f`lse
true