>I have another field that I alltrim that doesn't have a index in the same table and it only saves the exact number of characters that was typed in. I read about the problem with alltrim not working in a where statement but is says it was fixed in vfp 3.0b I am using vfp5.
>
> Thanks Kelly
A character field will always save the length of the defined field. Always. The only variable length fields in VFP are memo and general.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer