SQL Server CASE Law

SQLs CASE expressions can be powerful magic, but can trap the unwary who are used to the more familiar CASE...