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 vote143 views1 answer
Default value false mysql
SQL
3 votes135 views1 answer
Select nextval from sequence sql
SQL
0 vote223 views1 answer
Add user mysql wordpress
SQL
1 vote171 views3 answers
How to update column name in psql
SQL
1 vote134 views6 answers
In sql
SQL
0 vote138 views1 answer
How to set sql_mode for a query in CI model
SQL
1 vote138 views2 answers
Oracle create synonym
SQL
1 vote149 views1 answer
Mysql how to truncate table with foreign keys
SQL
1 vote135 views1 answer
Oracle stop job
SQL
2 votes144 views1 answer
Sql find not in list
SQL