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 vote106 views1 answer
Update from select join
SQL
0 vote106 views1 answer
Mysql database hyphen
SQL
0 vote111 views1 answer
Sqlalchemy query join many to many
SQL
5 votes137 views1 answer
Migrate sql table another database
SQL
0 vote109 views1 answer
How to install postgresql on wsl
SQL
0 vote114 views1 answer
How to find date from date table in sql
SQL
0 vote104 views1 answer
T-SQL Never ending DELETE
SQL
39 votes174 views4 answers
Select duplicates in sql
SQL
0 vote100 views1 answer
Minus equivalent in my sql
SQL
4 votes111 views1 answer
For loop postgresql
SQL