Wow, read my email backwards and totally missed the fact that IFIN had already been discussed.
Sorry for the email intrusion (twice!) Duey -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis McGrath Sent: Wednesday, May 07, 2008 2:54 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: IFLTEQ I LOVE IT! Great idea, Larry! Dennis -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Lustig Sent: Wednesday, May 07, 2008 2:51 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: IFLTEQ << What I could use is IFIN(list, truevalue, falsevalue) >> Please -- even better: IIF(Condition, Value1, Value2) let's you do: IIF(vMyVar IN (. . .), 'YES', 'NO') IIF(vMyVar >= .vSomething, .vMyVar, .vSomething) IIF(vMyVar IN (. . .) AND vMyVar >= .vSomething, .vMyVar, NULL) and so on. Any condition that could be accommodated in the standard IF/THEN would work. -- Larry --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
