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

0 vote147 views3 answers
Mysql calculate age from date of birth
SQL
3 votes200 views1 answer
Oracle function return
SQL
33 votes198 views6 answers
Sql delete
SQL
3 votes168 views1 answer
Pl sql check if variable is empty
SQL
0 vote167 views1 answer
Sql requete number pair
SQL
0 vote187 views1 answer
Php get closest location by latitude longitude
SQL
9 votes215 views2 answers
SELECT User,Host FROM mysql.user;
SQL
2 votes185 views1 answer
Mysql set value as null
SQL
1 vote167 views1 answer
Adding a default constraint to an existing column in sql
SQL
7 votes186 views1 answer
Set sequence value oracle
SQL