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 ?

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

TIA,

Yannis