Sql case update

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 vote198 views1 answer
Oracle compile schema
SQL
0 vote187 views1 answer
Restore backupfile discourse
SQL
5 votes202 views1 answer
Invalid column name sql
SQL
0 vote209 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
4 votes222 views2 answers
Postgresql float data type
SQL
0 vote216 views1 answer
How to set up an anonymous function to variable in swift
SQL
9 votes208 views3 answers
Where clause sql
SQL
6 votes246 views3 answers
What is where in sql
SQL
21 votes201 views5 answers
Oracle all tables
SQL
79 votes358 views6 answers
Grepper code
SQL