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 vote257 views1 answer
How to connect sql server using ip address in c#
SQL
3 votes328 views2 answers
Oracle privileges users
SQL
19 votes323 views6 answers
What is mySQL
SQL
0 vote308 views1 answer
Psql not found windows
SQL
1 vote354 views1 answer
T-sql disable system versioning
SQL
6 votes343 views3 answers
How to delete table sqlite
SQL
10 votes321 views4 answers
Drop primary key
SQL
0 vote345 views1 answer
Influxdb list all tags for a measurement
SQL
20 votes305 views2 answers
Counting in sql
SQL
0 vote359 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL