Great enhancement! Regards, Stephen Markson ForenSys The Forensic Systems Group www.ForenSys.ca 416 512 6950
> -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence > Lustig > Sent: May 7, 2008 3: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 > > No virus found in this incoming message. > Checked by AVG. > Version: 7.5.524 / Virus Database: 269.23.9/1419 - Release Date: 07/05/2008 7:46 > AM > No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.9/1419 - Release Date: 07/05/2008 7:46 AM
