Archives of the TeradataForum

Message Posted: Tue, 15 Nov 2005 @ 12:00:39 GMT

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

Hi All,

Am trying to do this formula in a view

     Case when Rate = 'Credit' then (balance* Irate)/12*100 end

When I run the view it say numeric over flow.

I tried to use the Cast function but I cannot get it to work.

Could you please help me with the cast function.

Regards

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