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