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 votes189 views2 answers
Sql percentage
SQL
0 vote192 views1 answer
Create table using the clause with as
SQL
1 vote166 views1 answer
Floor function in sql oracle
SQL
0 vote177 views1 answer
Sql server remove enter from string
SQL
5 votes257 views1 answer
Oracle sysdate - 1 month
SQL
0 vote243 views1 answer
Fetching data from mysqldb
SQL
11 votes202 views4 answers
Reset identity column values in sql server
SQL
0 vote194 views1 answer
Mysql drop trigger
SQL
1 vote192 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote190 views1 answer
Bitmap join index
SQL