Thanks all ... Not only is the brain fuzzy.... its OLD Wildcard fuzzy !
Dick
On 4/9/2012 12:02 PM, Dick Fey 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
