If u use oracle 8i and 9i u may use CASE expression.
DECODE() and CASE .. WHEN .. on server side
in any case faster then IF/ELSE on client side.