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
Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN
If a vegetarian eats vegetables, what does a humanitarian eat?