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

4 votes175 views2 answers
SELECT table_name FROM user_tables;
SQL
2 votes174 views2 answers
Change mysql password from command line
SQL
0 vote182 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
0 vote172 views1 answer
T-sql check if data exists
SQL
0 vote160 views1 answer
IIF
SQL
1 vote181 views2 answers
Extract weekday from date in sql
SQL
2 votes170 views3 answers
Replace null in sql
SQL
1 vote169 views1 answer
Pentaho + pasar de excel a sql
SQL
4 votes164 views1 answer
Update table from another table oracle
SQL
2 votes182 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL