Dirty Secrets of the CASE Expression Detailed guide with T-SQL CASE expression explanation, examples, and common misconceptions, including WHERE clause and other best practices. Aaron Bertrand ◆ June 12, 2014 38