>Hi Walter,
>
>yes, but it your case, why? INDEX ON FirstName-LastName gives EXACTLY the same result! One of the little used features of xBase.

This is not true:

FirstName-LastName 
is
PADR(RTRIM(FirstName)+LastName,FSIZE(FirstName)+FSIZE(LastName))

>
>OK, I admit I should have use the word "as", and not "in". 'Never use alltrim as an index expression. Thank you for the correction.
>
>>Hi Tore,

Then:

Never use LTRIM()
Never use RTRIM()
and then
NEVER USE OF A VARCHAR FIELD ON VFP9 !

The issue appear when you use this into a primary/candidate index,
and this is true for cExp1-cExp2 also.

For a search text index, ALLTRIM(),LTRIM()... can to be used without problems.

Fabio