HOW TO

Query even or odd values in a field stored in a File or Personal Geodatabase Feature Class

Last Published: April 25, 2020

Summary

Instructions provided describe how to query even or odd values in a field.

Procedure

The expression is set to 0 for querying even records and 1 for querying odd records.

  • For personal geodatabase tables, use the following:

    [field] MOD 2 = 0
    [field] MOD 2 = 1

  • For database file format (DBF) or file geodatabase tables, use the following:

    MOD( "field" ,2) = 0
    MOD( "field" ,2) = 1

Article ID:000009549

Software:
  • ArcMap 8 x
  • ArcMap 9 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic