>>What if you pad with spaces the 'ADL66609' value so it matches the length of the DocNumber field? I will bet that works as well. Not sure why you have that problem, because it works for me. I am using the MS VFP Driver v6.01.8629.01
>
>No, no the problem is that it is not finding any records that start with ADL66609. If I did the first query from the VFP command window I would get 6 records in my cursor. But not through ODBC. Does ODBC to VFP table not respond the same way as VFP command window SQL or is ODBC interpreting the = as exactly equal and not starts with like VFP does in its SQL.

OIC! I do get the same results if I just query on the first letters of a string. That is I get no records. But, if I pass the complete string, I do get matches. Otherwise, I have to use LIKE operator.