try '__' 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 > > > -- William Stacy, O.D. Please visit my website by clicking on : http://www.folsomeye.net
