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