O'Reilly logo
  • Dustin Waybright thinks this is interesting:

SELECT productid, productname, unitprice, discontinued, CASE discontinued WHEN 0 THEN 'No' WHEN 1 THEN 'Yes' ELSE 'Unknown' END AS discontinued_desc FROM Production.Products;

From

Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012

Note

The simple form looks for values in an expression.