>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