Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Previous sectionNext section


Returns the logical complement of an expression.




expression An expression that resolves to a boolean value.


The NOT function returns the logical complement (inverse) of a boolean expression. Thus all expressions that evaluate to 0 become 1, and all expressions that evaluate to 1 (or any non-zero numeric value) become 0. A string is parsed as a number until a non-numeric character is encountered. Thus “7dwarves” is parsed as 7 (boolean 1), and thus NOT returns 0. If expression is the null string or a non-numeric value, NOT parses it as boolean 0, and thus returns 1.

You can use the ANDS and ORS functions to perform logical comparisons on two values (either single expressions or arrays).


The following example uses the NOT function to return the inverse of a boolean expression:

PRINT NOT(1);          ! Returns 0
PRINT NOT(0);          ! Returns 1
PRINT NOT(7);          ! Returns 0
PRINT NOT(-7);         ! Returns 0
PRINT NOT("7dwarves"); ! Returns 0
PRINT NOT("fred");     ! Returns 1
PRINT NOT("");         ! Returns 1
Copy code to clipboard

See Also