No. You don't need set the set order.
The problem is the Like expression is not full optimizable.
Try to chage to AT command. P.e
Selec * from mydbf where At(field1,cValue)>0
"Anyone who has never made a mistake has never tried anything new." A.E
"The important thing is not to stop questioning. Curiosity has its own reason for existing." A.E