>>Is it advisable to use ALLT(field1) in index expressions and what
>>are its advantages and disadvantages.
>>
>>Thanks in advance.
>>
>>Shashi
>
>I use ALLTRIM() for all my indexes, I have to use them because in some cases what you have on your textboxes it's not the same you have in your fields.
>
>"name " is not equal to "name"

Plinio,

You are wasting cpu cycels because VFP pads the field back out to be a constant length when you use ALLTRIM(). SET EXACT OFF and "Name " = "Name" will be equal.