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