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


Reply via email to