Guys, with LIKE operator indexes NEVER used, so setting index order only can slow down query. If you want to use indexes, use something other than LIKE, for example, following expression lists all that starting by certain string:
cName>='Tom' AND cName < 'Tomzz'
Will show
Tomas
Tomundi
Tomasso
etc.



>>Do you have an index for the field that you are looking for?
>
>Yes I have an index for this field, but another litle question ?
>
>I'm using select * from dbc!dbf wher "LIKE" "%nametofind"
>
>Did I have to open the table and set this to the field order before I run the query expression for speed up my query ? or
>
>How could I Specify to my select sentence to use the index for the field ?
>
>Thanks for your answer