Select only whole integers

[polgara]

Need to run a query against a table to show entries that are whole integers. This is needed because some people have entered in the wrong currency due to a misunderstanding and the most probable illustration of this - a crude way of QAing

 

[namliam]

you can use int(field) = field
or
field * 100 mod 100 = 0

both returning true for integers...

Regards