>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
INDEX ON STR(nField1,10) + STR(nField2,10) TAG TwoFileds
--sb--