CASE (Transact-SQL) - MSDN - Microsoft

Simple CASE expression: CASE input_expression WHEN when_expression .... the CASE expression in an UPDATE statement to determine the value that is set  ...

msdn.microsoft.com