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

2 votes315 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote362 views1 answer
Add two days to current date in sql when creating tables
SQL
3 votes298 views1 answer
Ms sql skip take
SQL
0 vote312 views2 answers
Collation in sql
SQL
0 vote302 views1 answer
Varchar format not case sensitive sql
SQL
0 vote330 views1 answer
Reset postgres table index to next max value
SQL
0 vote293 views1 answer
How to find top 3 salary in sql
SQL
11 votes294 views2 answers
Import sql file laravel cmd
SQL
6 votes291 views1 answer
Allsource oracle
SQL
2 votes317 views1 answer
Mysql application.properties spring boot
SQL