Re: How to eliminate divide by zero error

> Sorry Daniel,
> My attempts to incorporate the COALESCE function failed,
> therefore I omitted that from the code to eliminate confusion. I'm
> using Oracle 9 and I simply want Null to return '0' as a blank record
> in this case essentially means zero.

NVL will do it.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org