The only way to get rid of the case expression would be to build a table that contains a cross-map of the values.
Then in your query you would join (outer join) to this table and pull the value you want.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs