Subject Re: About UDF's problem
Author Adam
> 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.


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