Subject Re: [firebird-support] How to conditionally sum and count rows in Firebird?
Author Paul Vinkenoog
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