Archives of the TeradataForum

Message Posted: Wed, 17 Jul 2002 @ 13:40:18 GMT

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

As a side note, I tried casting this value to a field with a digit after the decimal point and it displayed the values correctly:

select storenumber, monthid, commoditycode, cast(gallons as Decimal(12,0)) from prismstoregallonsales;

hmmm. puzzling.

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