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?

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird links :
http://www.firebirdsql.com
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/


Nederlandse firebird nieuwsgroep :
news://80.126.130.81