Do you really need an index, or would a properly ordered cursor do?
select A,B,C from mytable into myorderedcursor where (any conditions) order by a asc, b desc, c asc
>Hello all,
>
>I have a table with character fields A, B & C
>
>I need to create an index on A (ascending) + B (descending) + C (ascending) to display in a grid:
>
>Apple | Mac | New Hampshire
>Apple | Mac | Washington
>Apple | Granny | New Hampshire
>Apple | Granny | Washington
>Apple | Delicious | New Hampshire
>Apple | Delicious | Washinton
>
>What index expression can I use to accomplish this?
>
>Many thanks,
>
>Ellis
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________