hello,
I want to convert 11.234 to 11.23(or 22.456 to 22.46) in stored procedure.I want to use the udf.First,I don't find which function is good.
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.




---------------------------------
DO YOU YAHOO!?
雅虎免费G邮箱－中国第一绝无垃圾邮件骚扰超大邮箱

[Non-text portions of this message have been removed]