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 vote335 views1 answer
See the structure of a table mysql
SQL
0 vote362 views1 answer
Sql datum formatieren
SQL
3 votes323 views1 answer
Locate sql server
SQL
1 vote296 views1 answer
Sql try catch
SQL
1 vote323 views1 answer
Oracle compile schema
SQL
11 votes340 views2 answers
Oracle source code
SQL
0 vote322 views1 answer
Mysql multiple group by
SQL
0 vote337 views1 answer
Write SQL in ruby on rails
SQL
0 vote385 views1 answer
Scheduled mysql database backup in linux
SQL
0 vote334 views1 answer
Plsql check how much space all databases are consuming
SQL