AnsweredAssumed Answered

SQL Query - Select all Tenth Only Records

Question asked by arepsher on May 4, 2015
Latest reply on May 4, 2015 by arepsher

I have a milepost dataset with too many records and want to cut it down to size.  I only need records with an "even" tenth of a mile (0 for hundredths - See Below).  The field is numeric.  Is this possible in a SQL query in Desktop?

MileEvenTenths.PNG

Thank you,

--Adam

Outcomes