Comparison Operator Reference

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 building whose street number is greater than 100 but less than 200, your expression would be:

Building_Street_Address > 100 AND Building_Street_Address < 200

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

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

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