SQL Server June 12th, 2014 Dirty Secrets of the CASE Expression I look at some unexpected behavior with the CASE expression and some of its derivatives.