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 votes143 views1 answer
Add new column not null sql server
SQL
0 vote136 views1 answer
Oracle table privileges
SQL
0 vote133 views1 answer
Sql select column names starting with
SQL
0 vote149 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
0 vote131 views1 answer
How to see password mysql vestacp
SQL
1 vote138 views1 answer
Sql try catch
SQL
0 vote138 views1 answer
Sqlite3_open_v2
SQL
6 votes126 views1 answer
Oracle list primary key
SQL
1 vote134 views1 answer
Mysql alter decimal precision
SQL
0 vote143 views1 answer
Sql values that contains certain multiple ids
SQL