Archives of the TeradataForum

Message Posted: Fri, 08 Dec 2006 @ 10:49:44 GMT

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

<-- Anonymously Posted: Friday, December 08, 2006 05:52 -->

Try the following. It might help.

     Create table tb1(c1 decimal(10,0));

     Select (cast((c1 mod 100000) as integer))/10000 from tb1;

Thanks, Anomy.

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