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 vote214 views1 answer
Sql select column name like from multiple tables
SQL
0 vote156 views1 answer
Big query add table rows to another table
SQL
1 vote274 views1 answer
Top 10 rows in mysql
SQL
1 vote226 views1 answer
Mysql default port
SQL
0 vote212 views1 answer
Sql server size of every table in a db
SQL
0 vote216 views1 answer
Top 3 salary in sql
SQL
1 vote248 views1 answer
Oracle extract minute from date
SQL
0 vote192 views1 answer
Commit transaction sql
SQL
0 vote195 views1 answer
Add column to table with default value plsql
SQL
1 vote223 views1 answer
T-SQL Alter the column data type
SQL