>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
If it is for a report, I would just create a cursor, and then print the report:
select * from client;
order by name descending, zipcode ascending;
into cursor TempResult
report form ...
Otherwise, if you really insist on indexing on character descending, that can be quite tricky. I suppose you could create a UDF that replaces each character with 255 - character (using the numeric character values, of course).
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)