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.
Last Modified: 11-OCT-00