Chapter 2: DataWindow Expression Functions

IsNull

Reports whether the value of a column or expression is NULL.

IsNull ( any )

Argument	Description
any	A column or expression that you want to test to determine whether its value is NULL

Boolean. Returns TRUE if any is NULL and FALSE if it is not.

Use IsNull to test whether a user-entered value or a value retrieved from the database is NULL.

This expression returns TRUE if either a or b is NULL:

IsNull(a + b)

This expression returns TRUE if the value in the salary column is NULL:

IsNull(salary)

This expression returns TRUE if the value the user has entered is NULL:

IsNull(GetText())