--- In firebird-support@yahoogroups.com, Hans <hhoogstraat@...> wrote:

>
> Maybe
>
> Select coalesce(value,'EOF') from table where id = someidnumber into
> someresult;

Coalesce will not work for empty sets. It will only work if there is 1
record and that record contains a null.

Adam