When i use a coalesce sentence over a query that returns no rows like
this:

select coalesce(null ,0) as alwaysnull
from rdb$database
where rdb$relation_id < -100000

The coalesce is ignored and always returns the null value... how could
i secure that this kind of querys returns a predetermined value for
some fields perhaps the query returns no rows????

Thanx in advance

Carlos