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 vote355 views1 answer
Sql sort column by date
SQL
1 vote329 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
0 vote369 views1 answer
Query string starts with vowels
SQL
-1 vote370 views1 answer
Auto increment psql not primary key
SQL
1 vote399 views3 answers
Epoch to datetime
SQL
6 votes376 views2 answers
Difference between join vs union
SQL
0 vote400 views1 answer
Mysql get first 2 characters of string
SQL
0 vote361 views1 answer
Sql where part of string match
SQL
0 vote345 views1 answer
Sql track modification
SQL
7 votes432 views2 answers
Drop index oracle
SQL