Check this out: http://www.w3schools.com/sql/sql_like.asp
On Mon, Apr 9, 2012 at 10:02 AM, Dick Fey <[email protected]> wrote: > 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 > >
