Using IF statements in Select statements

I have the following SQL from SQLServer that I need to convert to PLSQL v 8:

SELECT FD17 = CASE WHEN 17 - Sunset > 1 THEN 1 WHEN 17 - Sunset <

     0 THEN 0 ELSE 17 - Sunset END
FROM TABLE_FOO Sunset is a float

I was thinking that this:

SELECT DECODE(SIGN((17-Sunset)-1), 1, 1, -1, 0, 0, 17 - Sunset) as FD17 FROM TABLE_FOO would do it but it does not account for the case when (17 - Sunset)<=1 and > 0. Any ideas?
-Casey

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 01 2000 - 18:25:47 CST