selecting multiples of 10

[PamBrangan]

Hi - I have a data layer that has 5 ft contour intervals.  I would like to extract only the contours that are multiples of 10, so that I can have a data layer that is 10 ft contours.  What is the selection query I need to get this to work?

Thanks in advance for any help; I am tired of banging my head on this one!

Pam

[RichardFairhurst]

Hi - I have a data layer that has 5 ft contour intervals.  I would like to extract only the contours that are multiples of 10, so that I can have a data layer that is 10 ft contours.  What is the selection query I need to get this to work?

Thanks in advance for any help; I am tired of banging my head on this one!

Pam

The SQl you need is for the MOD function.  The syntax for its use depends on the database (PGDB, FGDB, SDE Oracle, etc.).  I believe the syntax for a FGDB is something like the following (assumes your contours have a field called ELEVATION):

MOD([ELEVATION], 10) = 0

[PamBrangan]

Thank you Richard!  That did the trick.  I'm going to save that query for future use.