Rounding numerical values in a stored procedure

By: Borland Staff

Abstract: A UDF is the best way to round a numeric value to an integer

Problem:
How to round a NUMBERIC number to an integer number

Solution:
Try a UDF rather than a stored procedure.  Stored procedures 
have the same data semantics as the database.  UDF's have 
the data semantics of the programming language in which they 
are written (e.g. NULLs are not supported).  You may invoke 
rounding UDF from a stored procedure if you wanted to use all 
possible mechanisms. 

Server Response from: ETNASC04