Hi Hilmar,

>How about indexing on padr(MemoField, 250)?

Obviously, this generates a "Invalid key lenght".

The max possibilities are:

INDEX ON PADR(FieldMemo,240) TAG TAG1 && if FieldMemo is not nullable
INDEX ON PADR(FieldMemo,239) TAG TAG1 && if FieldMemo is nullable

but next is equal and faster ( to index on,reindex,maintenance and seek):

INDEX ON LEFT(FieldMemo,240) TAG TAG1 && if FieldMemo is not nullable
INDEX ON LEFT(FieldMemo,239) TAG TAG1 && if FieldMemo is nullable

Fabio