That is one little "GOTCHA" I will have to look out for, especially when using the IIF statement!
>Yes, in such case FoxPro will try to fit the rest of values for that column in the field size 1. In VFP9 new CAST() function helps greatly to resolve such problems.
>
>>So, you are saying, that if the first value returned for a field in a query is, say 0, then the subsequent values returned for that field must be of length 1, also?
>>
>>>Nothing new here. The size of the field in a query result is determined by the values in the first record of the source table
>>>
Tommy Tillman A+ NetWork+ MCP