Archives of the TeradataForum

Message Posted: Mon, 09 Nov 2009 @ 10:59:46 GMT

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

Hi Ajai,

A crude way of doing this could be

     sel substr( trim(cast(column_name as char(10)))
       , index(trim(cast(column_name as char(10))) , '.')+1)

e.g.:

     sel substr( trim(cast(33.43 as char(10)))
       ,index( trim(cast(33.43 as char(10))) , '.')+1)

regards

Prahlad

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