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

0 vote245 views1 answer
Virtuoso sql query tutorial
SQL
6 votes228 views2 answers
Mysql interval 1 day
SQL
0 vote209 views1 answer
How to find unique key in sql
SQL
-1 vote210 views1 answer
Mysql select all columns and specific fields as
SQL
2 votes217 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
-2 votes214 views1 answer
Mysql not empty
SQL
3 votes222 views1 answer
Oracle apex warn on unsaved changes
SQL
2 votes214 views2 answers
Postgres drop column if exists
SQL
4 votes212 views1 answer
Sql delete where in select
SQL
0 vote203 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL