Archives of the TeradataForum

Message Posted: Wed, 25 Oct 2006 @ 21:20:26 GMT

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

Hi, there is a trick to round a decimal:

     select
     cast(10.4 as decimal(18,0))

     10

     select
     cast(10.6 as decimal(18,0))

     11

Bye.

_________________________________
Castelli, Emanuel Alejandro
Desarrollo DataWarehouse - IBM Argentina

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