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 vote238 views1 answer
Where name ends in SQL
SQL
1 vote223 views1 answer
Set statiscis on in sql server
SQL
1 vote225 views1 answer
How to give access to database in postgresql server to another user
SQL
2 votes240 views1 answer
Sql missing records from another table
SQL
0 vote218 views1 answer
Postgres add prefix to primary key
SQL
0 vote230 views1 answer
Oracle index hint
SQL
3 votes493 views1 answer
Postgresql cast
SQL
0 vote232 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote241 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL
0 vote248 views1 answer
Day of the week sqlite
SQL