venkat akella wrote:
....even if one column is NULL, then its effecting the whole query.
If you want NULL treated as zero numerically for col4, use coalesce(col4,0). Or you could find a way to get 0 into the column rather than NULL before the expression is evaluated.
HTH, Gerry ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------