At 07:27 AM 1/11/2008, you wrote:

>Hi all,
>
>any idea why a select like the following
>
> select coalesce(work_hours, 0), work_hours,
> case when work_hours is null then 0 else work_hours end
> from resource_allocation
>
>could return null in all fields ?

If you are using an GUI utility that returns a dummy set to a grid when the query returns no result, then you would see a row of nulls. The database server does not send this result: it is manufactured by your utility program..

>I am using firebird 1.5 on an win 2003 server, it's not the first time
>I am using coalesce and / or case and I did not notice such behaviour
>till now

Nothing has changed. Check whether your table has data.

./heLen