Archives of the TeradataForum

Message Posted: Fri, 31 Oct 2003 @ 00:23:39 GMT

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

You can also user the power notation.

Select col, col ** 2 /* col squared */, col ** 3 /*col cubed */, 'etc'

Square root also works , although you may need to cast to a real number format.

Eg. select 5 ** .5 (decimal (16,4))

Regards

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