Archives of the TeradataForum

Message Posted: Fri, 25 Feb 2011 @ 14:40:43 GMT

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

Hi

I am not a TD expert, but below works - I assume you have to guide TD by providing initial data with decimal point.

     select
     cast( (3995852.000 * 100 / 12274677) as Decimal(6,3) ) as Data_Pct

Lalit Shah
IT Technical Architect

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