Archives of the TeradataForum

Message Posted: Thu, 12 Apr 2007 @ 15:30:01 GMT

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

SQL Assistant can only display numerics up to 15 digits of accuracy.

If you want to see full accuracy for an 18 digit number (or 38 digit) you must select the option to 'Display full accuracy...' on the Answerset tab of Options. This will return the data as a character string and it will therefore maintain full accuracy. (Note that the column may not sort correctly unless you also check the sub-option to pad the data values with blanks.)

Mike Dempsey
Teradata Client Tools

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