Re: I can't believe I can't use IIF anymore!?!

Ah, typical Microsoft behavior, not reading the manual. Iif in Access, Sql server is decode in Oracle. Syntax
decode (expression, outcome1, result1, outcome2, result2, defaultresult)

Hth,

Sybrand Bakker, Oracle DBA

Patrick Joyal <please.reply_at_to.the.newsgroup> wrote in message news:38b44fee_at_news...
> you know, like :
>
> select IIF (Score >400, 'Congratulations!', 'Loser!') as Message ;
>
> to my surprise, it doesn't work in Oracle
>
>
>
Received on Wed Feb 23 2000 - 16:07:47 CST