Archives of the TeradataForum

Message Posted: Thu, 10 Apr 2003 @ 14:38:23 GMT

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

Srini,

Change Vdisplay1 to the following:

set vDisplay1 = select 5 /(2(decimal(4,2)));

When you divide two integers, e.g. 5/2, the result will be an integer. You must cast either the numerator or the denominator to a decimal first.

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