>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