Don't have Telegram yet? Try it now!
http://www.techmixing.com/2013/11/case-statement-expression-in-sql-server.html
Case Statement/ Expression in SQL Server