Hi Tommy,

Look at the NTOM() and MTON() functions. They'll convert numeric to currency (NTOM = Numeric TO Money) and currency to numeric (MTON = Money TO Numeric).

Why they didn't use NTOY() and YTON() I'll never understand (sigh)...

HTH.

>I'm having to do a SQL Select on an Access 95 database using Visual FoxPro 6.0
>
>One of the fields is type Currency.
>
>The value passed over to compare it to is of type Numeric.... so I get an operator/operand type mismatch.
>
>What is an easy way to compare the two?
>
>Thanks