Check the setting for:

Set Near
Set Exact

If wrong setting, you can't get it!!

For me, as the data is less like to occur twice in middle!

I use:

ALLTRIM(UPPER(?cCustNoWanted)) $ UPPER(cCustNo)

^_~ Good Luck!

---

>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