Archives of the TeradataForum

Message Posted: Wed, 20 Dec 2006 @ 09:28:32 GMT

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

Hi All,

I have tried executing the following query in teradata

     Coalesce(TRIM(Trailing '.' FROM(CAST( CAST(SUM(amount) As DECIMAL(13,2)
     FORMAT 'z(10)9.9(2)')AS VARCHAR(13)))),' ')

The above query works fine but removes the negative sign(-) from all the column values. However if i remove the format it works fine but i am not able to get the data in the desired format. Please help me out.

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