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

3 votes175 views2 answers
Df to sql pandas sql achemy
SQL
6 votes173 views1 answer
Oracle desc table primary key
SQL
17 votes240 views6 answers
Get last record in sql
SQL
0 vote223 views1 answer
Using distinct and count together in sql
SQL
0 vote188 views1 answer
Mysql error 1251
SQL
0 vote199 views1 answer
Mysql concatenate select results
SQL
0 vote167 views1 answer
Create table if not exist with exceptions
SQL
0 vote172 views1 answer
Postgres data location
SQL
2 votes172 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
34 votes192 views5 answers
Oracle alter table add column
SQL