Sql case sttement with set

UPDATE dbo.TestStudents  
SET     LASTNAME =  CASE  
                        WHEN LASTNAME = 'AAA' THEN 'BBB' 
                        WHEN LASTNAME = 'CCC' THEN 'DDD' 
                        WHEN LASTNAME = 'EEE' THEN 'FFF' 
                        ELSE LASTNAME
                    END 
WHERE   LASTNAME IN ('AAA', 'CCC', 'EEE')

Source: stackoverflow.com

Similar codes

1 vote345 views2 answers
Login to mysql
SQL
0 vote375 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote362 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
15 votes373 views4 answers
Mysql export database command line
SQL
14 votes353 views4 answers
Remove record from table sql
SQL
0 vote388 views1 answer
Pl sql disable trigger
SQL
0 vote358 views1 answer
Mysql a from on this page has
SQL
5 votes344 views2 answers
Add column postgres with default value
SQL
3 votes336 views1 answer
Oracle rollback
SQL
2 votes345 views1 answer
Sql missing records from another table
SQL