Comparison Operators
Operators
Date-Time Operators
Logical Operators
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. In order 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
|
|
( )
|
Groups the selection in parentheses.
|
(Value, Value)
|