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

0 vote388 views1 answer
Delete from IN subquery
SQL
0 vote361 views2 answers
Many to many flask-sqlalchemy
SQL
0 vote328 views1 answer
How to install mysql without admin rights
SQL
10 votes359 views2 answers
Mysql drop database if exists
SQL
31 votes337 views3 answers
SQL Server change column data type
SQL
4 votes341 views1 answer
Add constraint fk
SQL
0 vote376 views1 answer
How to print sql query
SQL
1 vote332 views1 answer
Oracle aleter trigger ora-01031
SQL
0 vote355 views1 answer
Dbms_output sql developer
SQL
1 vote335 views1 answer
Set statiscis on in ssms
SQL