>How can i create an index for two numeric fields thats result is same with this;
>
>select * from table1 order by a,b
>
>a and b are numeric fields.
>Thanks
Use STR() in the INDEX ON...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.