> Second, I use round func,as the example,the result is null,why?
> example in stored procedure:
> select sum(round(Field1))
> from table1,
> the result is null,but if:
> select sum(Field1)
> from table1,
> result is the value in talbe.
>
> Hope your reply,Thanks.
>
> Jinyang.
>
> regard.

Jinyang,

My guess is that Field1 contains null values, or all the values are
below 0.5 would also do it. What is the field type of "Field1"
(integer / float / etc). Does it help if you add "where Field1 is not
null"?

Adam