Archives of the TeradataForum

Message Posted: Fri, 12 Dec 2003 @ 20:07:52 GMT

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

<-- Anonymously Posted: Friday, December 12, 2003 15:03 -->

Why you want leading zeroes in a integer column. Leading zeroes will not stored in a INTEGER field . I am guessing you want to display leading zeroes when you select from the table. If that is the case then

SELECT INTEGER_COL (FORMAT '99999999') FROM TABLE ;

(Inorder to display this correctly in ODBC based products , Do a casting to CHAR(8) )

Thanks,

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