>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
? SEEK('11')
INSERT INTO byby VALUES ('12')
INSERT INTO byby VALUES (' 2')
? SEEK('1212')
? SEEK('22')
Fabio