Subject RE: [firebird-support] MAX
Author Robert DiFalco
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.


-----Original Message-----
From: Robert DiFalco
Sent: Tuesday, July 29, 2003 2:49 PM
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?