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 vote212 views1 answer
Sql group by error
SQL
6 votes214 views1 answer
Postgresql get year
SQL
4 votes258 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote236 views1 answer
Normalization in database 2nd normal form
SQL
0 vote215 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
0 vote245 views1 answer
How to get one year old query from plan cache
SQL
1 vote181 views1 answer
Strict in postgres SQL
SQL
-1 vote239 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote217 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
0 vote229 views1 answer
Grepper sql workbench download
SQL