All...
I have a query that calculates various using variables from a survey
database. As with any survey, there are many instantces of null values. I'm
wondering if there is any way to escape the error caused by dividing by zero
or null values. The specific message i get is:
ERROR: floating point exception! The last floating point operation either
exceeded legal ranges or was a divide by zero
Is there a simple trick that won't make my queries excessively complex?
Many thanks.
Mike
----------------------------------------
This mail sent through www.mywaterloo.ca