>In VFP9 you can use CAST() function to define exact type and size of the created field.
>
><snip>
>>Note the 0000.00 type of syntax. The place holder has to have the appropriate size so the column gets created properly if the first record is the 0 case.
>>Thanks to VFP 9!
>>
Hi Sergey,
I inserted in the wrong order. I meant "Thanks to VFP9" based on the ability to do UPDATE FROM x JOIN (SELECT * ) ON type of SQL code. I don't think this was possible before 9. But with regard to the structure, yes, CAST is good. I just wanted folks to know IIF(x = y, 0, x) in VFP SQL code won't always work as expected.
Charlie