Subject Re: [firebird-support] MAX
Author Arno Brinkman
Hi Robert,

For FB1.0 you can use UDF's for this.

I believe they are called xNVL() in the udf library.

> Sorry, I am using 1.0 because I need to support multiple platforms and
> we cannot get 1.5 to compile for Solaris. In 1.5 I could use NULLIF or
> COALESCE. As far as I can tell there are not available in 1.0.
> Is there a way, say in a sub select, to get the max of a column OR ZERO
> if there are no records matching the criteria? I think normally one
> would use Coalesce?

Arno Brinkman

Firebird links :

Nederlandse firebird nieuwsgroep :