Archives of the TeradataForum

Message Posted: Mon, 09 Nov 2009 @ 10:54:26 GMT

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

     CREATE TABLE TEST_MATISSA
     (
     COL1 DECIMAL(18,6)
     );


     SELECT COL1,SUBSTRING(COL1 FROM POSITION('.' IN COL1)+1) AS MATISSSA
        FROM TEST_MATISSA

Thanks

Krishna

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