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

0 vote321 views1 answer
Print orcale
SQL
11 votes385 views1 answer
Oracle insert from select
SQL
0 vote369 views1 answer
Doesn't have default value mysql
SQL
9 votes363 views4 answers
Postgresql export database
SQL
0 vote340 views1 answer
Restore backup mysql .gz
SQL
1 vote352 views1 answer
Mysql curdate between two dates
SQL
0 vote363 views1 answer
What is SQL data store?
SQL
22 votes319 views4 answers
Show list of users in mysql
SQL
0 vote346 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
1 vote299 views1 answer
Sql auto timestamp
SQL