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 vote129 views1 answer
How to check database engine in mysql
SQL
0 vote100 views1 answer
Import big data to mysql
SQL
0 vote108 views2 answers
Temp Space
SQL
7 votes98 views1 answer
Sql management studio display line numbers
SQL
0 vote100 views1 answer
Show the colums of table sql
SQL
9 votes98 views4 answers
Add primary key to existing table sql
SQL
4 votes100 views1 answer
Find tables with column name in sql
SQL
0 vote122 views1 answer
Update database collation in postgresql
SQL
0 vote148 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote102 views1 answer
How to order result of subquery in select
SQL