Thanks... I'll give em a try and see what happens.
>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
Tommy Tillman A+ NetWork+ MCP