Case is one of more beatiful and powerfull things in SQL programming.

Especially when you have several bit columns that translates to some states and then state as single parameter. (IsShipped, IsReady - for example)