>Hello Edward,
>
>I want to index on on group of logical fields (DESCENDING) and a character field (ASCENDING)
You may do something like:
INDEX ON IIF(logfield1=.T.,"B","A")+IIF(logfield2=.T.,"A","B").... +charfield TAG Mytag
Edward Pikman
Independent Consultant