>A former programmer at my company had applied an alltrim to an indexed field. When I removed the alltrim the report that uses the field ran several times faster. This alltrim seemingly nullified the index on the field. Is there any explaination to this?
>
>Thanks for all replies.
>
>Mike

Yea, I think so...

The program itself was most probably *NOT* using the ALLTRIM(IndexedFieldName) expression in its FOR or WHERE clause(s).

You'll want to make sure that there are not other parts of the application that slowdown because of your change, and if they do then I suggest that you change them to remove the ALLTRIM() in their expressions also .

It is general concensus that ALLTRIM() is NOT useful/sensible in a TAG expression anyway, so your first step was a good one (though no doubt lucky too).

good luck,

JimN