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?
This expression may work for you, though floating-point round off may cause issues, in which case you'd need to do something more complicated.
FLOOR("PERIMETER" * 10) = "PERIMETER" * 10
Thank you very much, Curtis Price.
That worked perfectly!
So I went the dirty route and just copied all records into a TEXT field. Given that the precision was only two decimal places in the original numeric field, I used the SQL query:
NUMinTEXT NOT LIKE '%.__'
The value is 'Percentage-Decimal-Underscore-Underscore'. This picks up everything with no decimal and one decimal place.
Would still like to know how do it in a numeric field if it is possible.
Retrieving data ...