Re: Re: Nulls vs Blanks?

aland@informix.com (Colonel Panic) wrote: >>and if you run an aggregate function (AVG,SUM,MIN,or MAX) on a column with >>nulls the function will return a null. > >Not generally true -- only if ALL qualified rows have NULL in that column >will those aggregates return NULL -- otherwise, the NULLs are *ignored*. Oops. You got me. The passege was in I-SQL Reference (ver. 4.0) p. 7-39, on the last paragraph. I re-read that paragraph, and I guess I combined two different sentences in that paragraph to come up with that answer =(. What can I say? It was late and after work. Next time i'll post stuff in the afternoon when I feel awake =). Rob Zook