>>>You may do something like:
>>>INDEX ON IIF(logfield1=.T.,"B","A")+IIF(logfield2=.T.,"A","B").... +charfield TAG Mytag
>>
>>Are you using this index to order the records in a report, or the rows in a grid, or for a reason such as that? I assume you are, since this index will be useless for Rushmore.
>>
>>If that's true, may I suggest that you will get better performance with a SQL SELECT which has an appropriate ORDER BY clause? Individual ORDER BY items in a SQL SELECT can each be specified with ASC or DESC keyword.
>
>Rich,
>If the purpose to show some sorting in grid then it's better then SELECT-SQL. Also, it's not completely useless for Rushmore.

OK, you could say not completely useless for Rushmore. But when are you really going to use an index expression like 'IIF(logical1, "B", "A") + IIF(logical2, "A", "B") + character' in a FOR or WHERE clause? Or do you just mean you can use it for SEEK commands?

I'm not saying you're wrong, I'm asking. For the most part, I "bow to your greater wisdom"...

Cheers,
Rich.