For some reason I have always written my Case statements using the following logic:   It wasn't until recently that I noticed that there is another syntax that can be used with the CASE expression, the interesting part about this other form is that it is rather aesthetically pleasing when dealing with multiple WHEN clauses... Continue Reading →