>Oops forgot the other part of the question.
>
>Is it possible to make the field2 show in descending order.
>like in:
>select * from table1 order by nfield1 asc, nfield2 desc
>
>
>???
>Thanks

How about:

insex on padl(field1,10,"0") + padl(2147483647 - field2,10,"0") tag Test

I think, it's not the best index from optimization point of view, but should work...

I'm not sure, bintoc function produces ordered set... Help tells nothing about it, in few cases I just tried, it does follow the order.

So, you may try index on bintoc(field1)+ bintoc(2147483647 - field2)