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 vote194 views1 answer
How to fetch unique records from two tables
SQL
0 vote223 views1 answer
Where date in datetime mysql
SQL
0 vote194 views1 answer
Oracle archivemode
SQL
1 vote199 views3 answers
Drop unique key constraint in sql server
SQL
-1 vote257 views1 answer
Sql show custom constraints
SQL
0 vote195 views1 answer
Mysql docker image arjun
SQL
0 vote164 views1 answer
Postgresql add leading zeros
SQL
0 vote229 views5 answers
How to make trigger in phpmyadmin
SQL
0 vote217 views1 answer
Mysql insert into select transaction c#
SQL
0 vote211 views1 answer
Hex string sql becomes int64
SQL