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

2 votes333 views1 answer
Oracle find unusable indexes
SQL
1 vote353 views1 answer
Postgres cast as currency format
SQL
0 vote387 views1 answer
Sql server query all database objects
SQL
-1 vote369 views1 answer
Brisanje dupliranih konatakata
SQL
0 vote342 views1 answer
Mysql Like(searching in the string)
SQL
0 vote423 views1 answer
Compress sql file database ubuntu
SQL
3 votes364 views1 answer
Oracle list privileges
SQL
0 vote359 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote327 views1 answer
T-sql check if data exists
SQL
19 votes317 views1 answer
Sqrt(-1)
SQL