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 vote206 views1 answer
Sql oracle update multiple rows
SQL
6 votes189 views1 answer
How to get the size of the database in postgresql
SQL
5 votes191 views1 answer
Oracle ora-00054 resource busy
SQL
2 votes256 views1 answer
Mysql create user with remote access
SQL
1 vote155 views4 answers
Fatal database postgres does not exist
SQL
12 votes157 views2 answers
Select into insert sql server
SQL
0 vote182 views1 answer
Carbon mysql d m y to y-m-d
SQL
1 vote189 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
0 vote190 views1 answer
Stop psql server windows
SQL
0 vote152 views1 answer
Sql server alter table column nullable
SQL