But one problem could occur if the vendor name doubles as a last name field, which is the special case of a two letter last name. At least in my database I've got lots of 2 character last names (Yu, Lu, Ng, etc)
On Mon, Apr 9, 2012 at 10:20 AM, William Stacy <[email protected]>wrote: > 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 > > > > -- William Stacy, O.D. Please visit my website by clicking on : http://www.folsomeye.net
