Sql case sttement with set

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 vote116 views1 answer
What is in operator
SQL
0 vote114 views1 answer
Sql server express download
SQL
3 votes106 views2 answers
To_char sql
SQL
1 vote144 views1 answer
Drop colum oracle 18c
SQL
2 votes106 views1 answer
Oracle sql query to make column data uppercase
SQL
23 votes155 views6 answers
Create table sql
SQL
0 vote132 views1 answer
Count database access django
SQL
1 vote130 views1 answer
Alter constraint in sql
SQL
0 vote127 views1 answer
Nodejs sql get one to many relationship as array
SQL
0 vote123 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL