Archives of the TeradataForum

Message Posted: Fri, 24 May 2002 @ 14:52:31 GMT

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

You're limited to 18 digits.

Looking at your example, it looks like you're trying to hold an employee number as a FLOAT. If so, you need to be careful because there are rounding errors that are inherent floating point data type and so there will be employee numbers that you won't be able accurately represent.

In my experience, a value like an employee number can be decomposed into fields or if it has to be that large, it needs to be held as a character string.

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