Archives of the TeradataForum

Message Posted: Fri, 26 Mar 2004 @ 20:27:09 GMT

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

select cast(cast(columnname as format '99999' ) as char(5) ) from tablename ;

used to left pad integers with spaces.

Use similar syntax for char fields.

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