--- In firebird-support@yahoogroups.com, Namit Nathwani
<namitnathwani@h...> wrote:

> Hi
>
> Thanks a lot Helen, Wilhelm, Agung for your suggestion to use CASE.
>
> At 01:19 pm 06/12/2004, you wrote:
> >Use a CASE expression - syntax is in the v.1.5 release notes.

Firebird 2 allows IIF as a shortcut for CASE:

SQL> select iif(1 < 2, 'yes', 'no') from rdb$database;

CASE
======

yes

C.