Yep.

Use following way if you're sure you compare only text:

instead of

field like "a%"

use

field between "a" AND "azzzzzzzzzzzzzz"

Above expression is optimizable. I also use it in VFP for search and use exact search, this gives more speed, probably because all other string comparison more quick because they exact ;)

>In foxpro, the = only compares the number of characters on the left. In ADO using VFP drivers, it does not seem to do so. It can be done using 'Select * from table where field like "a%"'. However, the "like" seems to be very slow. Is there any way to get the speed?