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 votes259 views1 answer
Query to check cpu utilization in oracle database
SQL
4 votes223 views2 answers
Postgresql float data type
SQL
1 vote145 views2 answers
Last working day in week date function in sql
SQL
5 votes190 views3 answers
Oracle first day of last year
SQL
1 vote604 views1 answer
How to lock table in mysql
SQL
0 vote229 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
0 vote179 views1 answer
Sql server manager close connection
SQL
1 vote145 views1 answer
Oracle boolean to varchar
SQL
5 votes195 views2 answers
Ranking functions in sql
SQL
2 votes168 views1 answer
Oracle sql drop table purge
SQL