Grigore Dolghin wrote: > I think I was misunderstood, though. I am not talking about usage in > SELECTs - I would to it with nested IIfs. I have mentioned the DO CASE in > original message's context, which was "ErrDesc = ICASE( .....", not a SELECT > command. > > I was talking about the equivalent: IIF() is the one-liner equivalent of IF, > ICase is the one-liner equivalent of DO CASE. > > And I'm outta here ;) > Grigore
If you're not aleady outta here ... Were you misunderstood or have you misunderstood - no offence intended. IIF and ICASE are *functions* - period. DO CASE and IF can only be used instead of ICASE and IIF when they are used in a User Defined Function Paul Newton _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
