I have a need to access VFP data through ODBC from
a VB app. The some of the queries need to perform
searches as VFP does with SET EXACT OFF. Is there
a way of doing this?

I've tried using the LIKE operator
(WHERE dmiProv.LastName LIKE 'MILL%') but this is
not optimizable and the query takes between two
and eight minutes over the network. I've also
tried using the '=' operator, but this works like
'==' (WHERE dmiProv.LastName = 'MILL').

Can anyone give me some direction on this problem?

...kt