Archives of the TeradataForum

Message Posted: Thu, 24 Feb 2005 @ 13:08:15 GMT

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

Vaidya,

Easiest way to get around these kinds of errors is to subtract a smallvalue depending upon the data you have and the data you want in the result.

For ex.

     select cast(9.99999999-0.0004 as decimal(5,4))

Regards,

Prasanna.

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