Archives of the TeradataForum

Message Posted: Thu, 06 Nov 2003 @ 18:32:50 GMT

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

Tony,

Your Define should define the column as Char(9) and in your insert part use a format '9999999v99' . That should take care of it.

Good Luck.

==================
Define
 Code_1              (Char(5))
,amount              (Char(9))
..
..
..
..

Insert into {tablename}  (
 Code_1
 ,amount
..
..
...
)
Values (
    :Code_1
   ,:amount (FORMAT '999999V99')
...
...
...
..
);

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