Using CASE in MS SQL

Code to update a field using “CASE” (instead of using if-then-else):