I didn't consider an empty set, just a select on a column which could
contain a value or not :)

----- Original Message -----
From: "Adam" <s3057043@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, April 10, 2007 4:28 PM
Subject: [firebird-support] Re: Empty Result Set / NULL handing


> --- 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
>
>
>
>
o.com/group/firebird-support/join
> (Yahoo! ID required)
>
>
>