If you are using 8i then you can use CASE statements.