Archives of the TeradataForum

Message Posted: Thu, 11 Sep 2003 @ 22:43:12 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

so if I want anything over the integer value to be rounded up like the SAS ceil function I would use the below (ie/ I want 2.1 to be rounded to 3, 2.0 to stay at 2, etc.)?

select sum(cast(mou+0.99 as integer)) as mou <---assuming 2 decimal places on the pre-cast value.

Can anyone see any issues with this?

Thanks,

Bruce

	<Prev	Next>		<<First	<Prev	Next>	Last>>