>If I have an index on UPPER(Field) and then do a LOCATE FOR UPPER(Field) = lcField, does Rushmore take advantage of that index?
>
>TIA,
>
>Alex
Yes. Rushmore would use existing index for optimization if normalized expression you use exactly matches normalized index expression and expression is Rushmore optimazable.
--sb--