Archives of the TeradataForum

Message Posted: Mon, 29 Nov 2004 @ 21:19:45 GMT

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

Define the input as char(x). place a format on the insert statement to format the data with implied point. The "S" on the end tells Teradata it is a Zoned-decimal format

     FORMAT '9(12)v99S'

Kyle Prescott
UnumProvident - Data Strategies, 3-South

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