Archives of the TeradataForum

Message Posted: Tue, 14 Dec 2004 @ 12:30:42 GMT

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

Try this

     select cast( (col_name (FORMAT '9(09)')) as char(9))

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