Archives of the TeradataForum

Message Posted: Tue, 22 Jul 2003 @ 10:23:12 GMT

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

Use the CASE feature ...

sel case
    when col_name > 0 then +1
    when col_name < 0 then -1
    else '0'
    end
from table_name;

Sanjaya

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