>The following is a remote view of VFP data. I have a record of cCustNo = 'ABBA' and 'ABBB'. If I use 'AB' as my ?CustNoWanted field, I get no records returned. If I use 'ABBA' then I get the first one only. I want both. Set exact is off and set near is on and set ansi is off. Maybe it's the hour, but I need help....
>
>Create SQL View CustBrowseCustNo ;
> ;
> connection elS-Adm shared as;
> select ;
> cCustNo , ;
> cCustType , ;
> cNameLas , ;
> cPhone1 , ;
> .f. as lSel;
> from ;
> Customers ;
> where ;
> cCustNo = ?cCustNoWanted ;
> order by ;
> cCustno
This is mostly a guess, but I bet that the SET ANSI setting is ignored when accessing the data through ODBC. The VFP ODBC driver is probbly deciding how the strings are compared, and attempting to emulate how most datasources handle this, by doing an exact string comparison. Try LIKE instead of =.
Erik Moore
Clientelligence