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 vote234 views1 answer
Mysql select random rows large table
SQL
1 vote238 views2 answers
Intersect sql
SQL
1 vote227 views1 answer
Sysdate in sql
SQL
1 vote223 views1 answer
Sql server insert into temp table
SQL
0 vote223 views1 answer
How convert into in in sql query
SQL
1 vote219 views1 answer
Mysql list bigger table
SQL
0 vote215 views1 answer
Find invalid datetime field
SQL
0 vote218 views2 answers
How to combine diff colmun value using group by postgres
SQL
1 vote205 views2 answers
Sql convert datetime to year month
SQL
2 votes242 views2 answers
Sql lag
SQL