>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"