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
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.