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

Why PADR ?

It is unnecessary.

CREATE CURSOR byby (c c(2))
INDEX on ALLTRIM(C)+ALLTRIM(C) TAG t1 && VFP build a key with LEN(KEY())=FSIZE('C')+FSIZE('C')
? SEEK('11')
INSERT INTO byby VALUES ('12')
INSERT INTO byby VALUES (' 2')
? SEEK('1212')
? SEEK('22')

Fabio