I've a strange behavior with an index:


The index is: ALLTRIM(CharField) + DTOC(DateField)

When I "append from othertable" with the same structure, the seek function does not find the record, if I issue REINDEX command, Seek function works fine!

Thank's in advance,
Nuno Pedro