Changing Data Types in a Query

[Corwyn]

Hello,
Currently I have a SQL 7 query used to check a price field for prices with more then 2 decimal places.

&quot;select * from foo where priceperunit <> (cast(cast((priceperunit*100) as int) as decimal))/100&quot;

I am trying to replicate this in a program to precheck data.
VB 6, using Jet to access an Excel spreadsheet.

Jet does not seem to like cast or convert (T-SQL functions).
Are there non-ansi functions available in this kind of query? Are they VBA functions, access functions. Where is a good list of functions available. Do I just use the VBA format function.

Any help would be greatly appreciated!