In the last example, could it not have been done with TWO case statements instead of four so long as each case statement contained only references to the same column...