>It may create fixed length index key, but it's not the size of the CDX file that I'm worried here. I want Rushmore to kick in and you need to have an index on ALLTRIM (movehist.destjob) for that. An index on movehist.destjob will not be used.
>
>>http://fox.wikis.com/wc.dll?Wiki~UdfsAndTrimsInIndexes~VFP

It would be better to use an expression in the locate and in the index that yields a fixed length value.

It would be even better to use SEEK instead of LOCATE in that method.