Logical Operator Reference

Logical operators are available from the Operator menu. They create conditions that return a value for a text property if it matches a particular pattern, or appears within a particular list.

When you create an expression for geospatial features, you can use the following logical operators:

Operator	Definition	Syntax
IS NULL	Returns the specified property if it is null. An expression with a bitwise or arithmetic operator evaluates to NULL if any one of the operands is NULL.	Property IS NULL
IS NOT NULL	Returns the specified property if it is not null. An expression with a bitwise or arithmetic operator evaluates to NULL if any one of the operands is NULL.	NOT Property IS NULL
AND	Combines conditions and matches a value if it meets all conditions.	Expression AND Expression
OR	Combines conditions and matches a value if it meets any one of the conditions.	Expression OR Expression
NOT	Negates a Boolean expression.	NOT Value
( )	Groups the selection in parentheses.	(Value, Value)