You need a wild card indicator such as 'AA%' OR 'A_' when using LIKE Dick if the column VVennum is defined as TEXT(2) then IF vvennum = 'AA' THEN should work the wild card indicator are normally "%" not "*" for multi charaters and "_" not "?" for single characters
Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 >________________________________ > From: Dick Fey <[email protected]> >To: RBASE-L Mailing List <[email protected]> >Sent: Monday, April 9, 2012 12:02 PM >Subject: [RBASE-L] - IF Like > >Guess my old brain is getting fuzzy. > >We use 2 letter codes for vendors (PH, QN,) etc. > >I want to call a specific vendors form if 2 letters are entered, search the >whole table if more than 2 letters > >Why does this code not work? > >IF vvennum LIKE 'AA' THEN > >IF vvennum LIKE '**' THEN > >IF vvennum LIKE '??' THEN > >IF vvennum between 'AA' and 'ZZ' THEN > >None will call a specific vendor, it always goes on to the else, which calls >all vendors having those letters in the name > > > >Old Fuzzy Brain, > >Dick Fey > > > > >
