Thomas & Paul,
Thanks for the links. I was using The Firebird Book for a reference and I see now it is based on 1.5. I'll use your links in the future. (now waiting for the next FB book to be released :)

Mike

--- In firebird-support@yahoogroups.com, Paul Vinkenoog <paul@...> wrote:
>
> Hi,
>
> > More recent versions of Firebird support the immediate if function
> > IIF(condition, true value, false value). See
> > http://firebirdsql.org/refdocs/langrefupd20.html Internal Functions.
>
> Or directly http://firebirdsql.org/refdocs/langrefupd20-iif.html
>
> Paul Vinkenoog
>