Posted by Robert Klemme on 09/02/05 19:16

manning_news@hotmail.com wrote:
> OK, maybe I have my avg function syntax wrong. Given the following
> set of values I get a Null result:
>
> <column names>
> systems1 systems2 systems3 systems4 systems5
> 2 2 2 NULL NULL
> 3 4 5 5 NULL
> 4 1 2 4 NULL
>
> select avg(systems1+systems2+systems3+systems4+systems5) from
> tblEvaluations

select
avg(ISNULL(systems1,0)+ISNULL(systems2,0)+ISNULL(systems3,0)+ISNULL(system
s4,0)+ISNULL(systems5,0)) from
tblEvaluations

robert

• Next in forum: Re: Slow Query Through Cold Fusion
• Prev in forum: Re: Getting Avg to really ignore null values
• Thread view: Re: Getting Avg to really ignore null values

[Reply to this message]