One always runs in to trouble eventually when one db field has multiple meanings. A big part of the problem is remembering the rules and the coding to support them. It just makes for difficult maintenance.
Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of William Stacy Sent: Monday, April 09, 2012 12:52 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: IF Like 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]<mailto:[email protected]>> wrote: try '__' On Mon, Apr 9, 2012 at 10:02 AM, Dick Fey <[email protected]<mailto:[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
