Archives of the TeradataForum

Message Posted: Fri, 06 Apr 2012 @ 16:56:17 GMT

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

Hi..

     select 123456.789654321  as etx,cast(etx as int)
            ||'-'||(substr(etx,position('.' in etx)+1))

Thanks,

Mahesh

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