Archives of the TeradataForum

Message Posted: Tue, 10 Oct 2006 @ 13:47:51 GMT

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

Rao,

You may want to correct this as you are casting to DECIMAL(17,2) but SUBSTRING has about 20.

     , substr(TableData,68,20)(Decimal(17,2))  c

Thanks,

Vinay Bagare

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