Archives of the TeradataForum

Message Posted: Thu, 03 Nov 2005 @ 14:02:34 GMT

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

Try using the format clause on the output:

     Trim( col1 (decimal(16,0),format'z(16)') )

Kyle Prescott
UnumProvident

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