CASE (Transact-SQL)

https://msdn.microsoft.com/en-us/library/ms181765.aspx