It could happen any time you use expressions that create a variable length result in a query column list.
>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.
>>
--sb--