Archives of the TeradataForum

Message Posted: Fri, 06 Apr 2012 @ 15:32:53 GMT

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

Couple alternatives

     SELECT 198.02345
              ,  SUBSTR(TRIM(198.02345 MOD 1) ,2) AS col1
              , 198.02345 (INTEGER) AS  col2
               , col2 || '-' || col1

     SELECT TRIM(198.02345) AS nbr
           ,  SUBSTR(nbr ,1,POSITION( '.' IN nbr)-1) AS col1
           , SUBSTR(nbr, POSITION('.' IN nbr)+1)  AS  col2
           , col1 || '-' || col2

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