Archives of the TeradataForum

Message Posted: Fri, 25 Feb 2011 @ 15:46:09 GMT

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

Attila - try the following. The precision is determined by the precision of the numeric values prior to the CAST.

     select
     cast( (3995852 * 100.000 / 12274677) as Decimal(6,3) ) as Data_Pct

Johannes de Wet
Unum

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