>>Is there a SQL-Statement way to change the precision of a field when SELECTING from ond dbf file into another? The source dbf has a numeric field of 20,2 that needs a change to 11,2
>
>CAST() function in VFP9.


Need help too:

My data tables is has a reference total field set up as Numeric(10,2). I need to calculate some child records (child.qty * child.price * child.markup), then compare that to a ref number stored in the parent header (I know, a bad practice, and I'm getting away from it soon).

So the SQL select is returning a sum like 254.0321 and even when I use Cast on the result, it will not test out as equal to 254.03.

llAuditPassed=Cast(csrAudit.nTestTotal as Numeric(10,2))=Parent.RefTotal will return .F.