>Select IIF(Far=.F.,Far2,0.00) as Far2 From Table1
>
>My Question , Why the Far2 is return 11 instead of -10.62 ??
Try this:
Select IIF( Far=.F., Far2, 00000.00 ) as Far2 From Table1
VFP used 0.00 (ie. a constant) to define Far2 in the SELECT as [4,2] ... though it did do a good job of jamming -11 into one digit.
This is one example of how VFP can corrupt numeric table data. I have also seen floating point numbers in fixed numeric fields.