Not Function

Inverts the logical result of an expression.

Syntax

Not (expression)

expression is the expression whose result is inverted. If expression is true, 0 is returned if false, 1 is returned. If expression is a null value, null is returned.

Remarks

expression is false if it evaluates to 0 or is an empty string. Any other value (except null) is true.

Examples

Here are some examples of the use of the Not function to invert the truth value of expressions:

Value1 = 5
Value2 = 5
Boolean = Not(Value1 - Value2);* Boolean = 1, that is, True
Boolean = Not(Value1 + Value2);* Boolean = 0, that is, False
Boolean = Not(Value1 = Value2);* Boolean = 0, that is, False