NULLIF

Returns a null value if the arguments are equal, otherwise it returns the value of the first argument. The arguments must be compatible. Character-string arguments are compatible with the datetime values. The arguments cannot be DataLink values.

Example:

Assume column PROFIT, CASH, and LOSSES have values 4500.00, 500.00, and 5000.00 respectively:

NULLIF (PROFIT + CASH, LOSSES )

Returns the null value.