English

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

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