Archives of the TeradataForum

Message Posted: Thu, 22 Jun 2006 @ 17:18:29 GMT

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

So the only problem is that you want the DECIMAL(18,4) field to display as '0.0000' if the value is zero? Just specify the alternative FORMAT either as the column default or via CAST. For example:

     ... CAST(CAST(DBS_Agmt_Hist_Amt AS FORMAT '-(14)9.9999') AS CHAR(20))...

[Default format for a DECIMAL(18,4) field would be '-(15).9999'.]

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