>Not sure why you want that. It will make Rushmore more difficult as every query will need to use the same method to optimize it. I agree with others that ORDER BY in the SELECT clause would be better.
>
>But, if you need it...
>
>INDEX ON DupKey + ("ZZZZZZZZZZZZZ" - Codex) + CopyNo TAG Docky


This solution will not work for several reasons, not the least of which is the minus sign is a concatenation operator in FoxPro. The result would be "ZZZZZZZZZZZother field".

Best regards,
Rick C. Hodgin


>
>Note the length of "ZZZZZZZZZZZZZ" is the same as the length of the Codex field.
>
>
>
>>I want to index a file on descending order of fields 1 and 2 but within that on ascending oder of fields 3 - how can I do this?
>>
>>I have tried this but it doesn't work
>>
>>index on dupkey+codex DESCENDING, COPYNO ASCENDING TAG docky