Archives of the TeradataForum

Message Posted: Tue, 22 Jul 2003 @ 09:59:54 GMT

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

Hi,

I want to get the sign of the data,

In SQL SERVER

SELECT SIGN(-5) will return -1,
SELECT SIGN(5) will return +1,
SELECT SIGN(0) will return 0.

Is any function like this available in Teradata?

Your help will be very much appriciated.

Regards

Ramesh

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