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?