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.

R.

-----Original Message-----
From: Robert DiFalco
Sent: Tuesday, July 29, 2003 2:49 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] MAX


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?

Robert