Comparison Operators

Comparison operators are available from the Operator menu. They modify a property value. Make sure that every instance of a comparison operator is preceded by a property and followed by a value. For example, if you create an expression to find every parcel whose street number is greater than 100 but less than 200, your expression would be:

Parcel_Street_Address > 100 AND Parcel_Street_Address < 200

In the example, the property Parcel_Street_Address is inserted twice. A single instance of Parcel_Street_Address does not work.

Numeric properties are evaluated arithmetically. Date properties are evaluated chronologically. Text properties are evaluated alphabetically. For example, Parcel_Area < 20000 will find parcels whose area is less than 20,000 square feet. Purchase_Date > 01/01/2001 will find parcels purchased after the beginning of 2001. Street_Address < “Mt. Whitney” will find parcels whose street address comes before Mt. Whitney alphabetically.

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

Operator Definition Syntax

=

Equals

Property = Value

Value = Property

>

Is greater than

Property > Value

Value > Property

<

Is less than

Property < Value

Value < Property

< =

Is less than or equal to

Property <= Value

Value <= Property

> =

Is greater than or equal to

Property >= Value

Value >= Property

< >

Is not equal to

Property <> Value

Value <> Property