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 |
|---|---|---|
|
LIKE |
Finds text that matches a pattern. The pattern you specify (within single quotation marks) can include regular characters and the percent (%) wildcard character. To match, regular characters must exactly match the characters specified in the pattern; the percent character can match an arbitrary fragment of the pattern. |
Property LIKE 'text%' |
|
NOT LIKE |
Finds text that does not match a pattern. You can use the percent wildcard as you do with LIKE. |
NOT Property LIKE 'text%' |
|
IN |
Determines whether a specified value matches any value in a list. |
Property IN (Value,Value) |
|
NOT IN |
Determines whether a specified value does not match any value in a list. |
NOT Property IN (Value,Value) |
|
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 NOT (Property = Value1) AND NOT (Property = Value2) |
|
( ) |
Groups the selection in parentheses. |
(Value, Value) |