Archives of the TeradataForum

Message Posted: Tue, 21 Dec 2010 @ 13:14:14 GMT

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

Hi ,

Is it possible to pad zeros to a variable and store it with zeroes in decimal field of tables.

For example

Consider the table1 having field tot_amount as decimal(5,0). The fields should have values like 00012,00123 etc

Regards,

Vijay

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