I've always wanted IFIN -- same as: IF vstate IN (NE,IA) THEN Syntax example: SELECT (IFIN(state,'NE,IA','Yes','No')) FROM table
I think I submitted this one a long time ago, but I don't think anyone else had a use for it. Just an idea. Duey -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of James Bentley Sent: Wednesday, May 07, 2008 5:10 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: IFLTEQ Add my vote for IFGE and IFLE and IFNE (If not equal). this would complete the tests "<=", "<", "<>", "=", ">", ">=". You some times can simulate the "<=" and ">=" by fudging the test value. I know the "<>" is just could be simulated by reversing the return values of the "=" test but I am a great fan of symetry Jim Bentley --- Ramsour Mike <[EMAIL PROTECTED]> wrote: > Try submitting this as an enhancement request -- please. This > has been > mentioned more than once over the years but has never been > implemented > TTBOMK. I would love to see this SuperMath function, too! > > I prefer IFLE and IFGE. > > Mike Ramsour > AK Steel Coshocton Works > Quality Department > > Phone/VMS: 740-829-4340 > -----Original Message----- > From: jan johansen [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 07, 2008 2:07 PM > To: [email protected] > Subject: [RBASE-L] - IFLTEQ > > I have used > IFEQ, IFLT, IFGT,IFNULL > > Now it looks like I have a need for > IFLTEQ (IF <=) > and > IFGTEQ (IF>=) > > These are for computed columns. > Suggestions or enhancement request? > > Jan > > > Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 ________________________________________________________________________ ____________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
