Comparison operators are available from the Operator menu. They modify a property value. Make sure 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 above, notice that the property Parcel_Street_Address is inserted twice. A single instance of Parcel_Street_Address will 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 20000 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: