Dick I would check the length of the variable if it is 2 then call you specific vendors form
IF (SLEN(.vvennum)) = 2 then EDIT USI yourSpecificFormHere ELSE DO something else here ENDIF -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dick Fey Sent: Monday, April 09, 2012 1:03 PM To: RBASE-L Mailing List Subject: [RBASE-L] - IF Like 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
