>How and where would I specify an index that sorts records by name in descending order AND zipcode in ascending order.
>
>Thanks for any replies,
>
>Mike
You'd need a tricky sort like :
index on name+padl(99999-int(val(zipcode),5) tag mySort descending
Cetin