When creating query clauses to perform equality / inequality, operations you should consider whether large floating point numbers can be avoided as they cause rounding errors.
You should also avoid using statements similar to the following:
<Field> = "Value"
Or:
<Field> <> "Value"
Consider using < or > (less than or greater than) to select rows with large integer values as this offers a greater level of precision.
Example:
The following query clause will cause rounding errors, which makes it impractical to perform equality / inequality operations against:
( FULLSCALE <> 3.402823e+38 ) AND ( POINTTYPE < 5 )
This query would be better written:
( FULLSCALE < 100000000 ) AND ( POINTTYPE < 5 )
This gives a better result.