Easy query question (Even Numbers)

[jessel]

Hello All,

I have a very quick SQL question... I am using GIS software (geographic information systems) to perform a query on a table (the software I'm using is ArcGIS, specifically). But this software in essence uses Access database structures, and queries can be written using the same SQL.

I am trying to select records from a numeric field. This field holds contour elevations, so the numbers are by tens, i.e. 310, 320, 330, 340, etc. I want to specifically select records in which the elevation number "ends" in 20, 40, 60, 80, or 00. I assume I need to isolate the last two numbers in this particular field, but I am unsure as to the exact SQL code I should use...

Any suggestions?

Thanks!

 

[BLeslie88]

Hi

This should work

Where Right([tblxx].[Grade],2) IN ("80", "60", "40", "20", "00")

Regards,