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 vote159 views1 answer
Create table split string function in sql server
SQL
0 vote142 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
0 vote148 views1 answer
1 column values in to 1 single row in sql
SQL
0 vote186 views1 answer
Select count concat string sql server
SQL
0 vote155 views1 answer
Selecting duplicates
SQL
11 votes145 views2 answers
Oracle all source
SQL
0 vote153 views1 answer
Drop specific row postgresql
SQL
0 vote151 views1 answer
Oracle create table auto generated primary key
SQL
0 vote144 views1 answer
Report in database
SQL
5 votes187 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL