Wow - I see this thread is resolved already - but I just have to put my two cents in.

The syntax in the OP is clear. And more important very, very easy to maintain and enhance. It's the "enhancing" part that's key here - if the list in intended to be added to - or altered - then the single case / value list is optimal in that regard.

And didn't that just get proved by the 30 posts about other ways to do it what were simply not clear - or buggy - or hard to even tell?

3rd cent...

Coming from a SQL background I am a big proponent of CASE ELSE - otherwise CASE statements in sql are "non-deterministic" and can return a NULL value...