T-SQL supports an expression called CASE and a number of related functions that you can use to apply conditional logic to determine the returned value.
- 2. Getting Started with the SELECT Statement
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
It is referred to as a CASE expression, not a statement.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/56862/