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?
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.