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,