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 vote145 views1 answer
SQL loop with cursor
SQL
0 vote164 views2 answers
Call to undefined function mysql_query()
SQL
2 votes160 views2 answers
How to run postgresql in linux
SQL
0 vote153 views1 answer
Create user faunadb
SQL
3 votes163 views1 answer
Oracle limit user tablespace
SQL
0 vote149 views1 answer
Mysql_num_fields in mysqli
SQL
0 vote137 views2 answers
How to set global time_zone in mysql
SQL
0 vote142 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
0 vote135 views2 answers
Add new column after in sql
SQL
0 vote117 views1 answer
Postgresql add leading zeros
SQL