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.
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,
>
>>Remove the ALLTRIM function!!! NEVER, NEVER, NEVER use ALLTRIM in an index expression! And this rule has NO exceptions!
>
>NEVER SAY NEVER :) . The rule is that each index expression should has the same fixed length. ALLTRIM() certainly is a threat but an index expression of:
>
>
INDEX ON PADR(ALLTRIM(FirstName)+ALLTRIM(LastName),40)
>
>is perfectly valid.
>
>Walter,