Something like this:
Index on padl(nField1,10,"0")+padl(nField2,10,"0")....

>I'm sorry but i haven't got a clue on how to do this.
>
>I'm want to create an index wich produces the same as the following sql-command:
>"select * from table1 order by nField1, nField2"
>
>both nFields are integer fields
>
>TIA