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

17 votes114 views3 answers
How to change a collumn name in sql
SQL
7 votes108 views1 answer
Buy forge mods server hosting
SQL
0 vote119 views1 answer
PSQL use LIKE with timestamps
SQL
1 vote95 views1 answer
Rows to comma separated values in mssql
SQL
0 vote100 views1 answer
Postgres week number
SQL
-1 vote149 views1 answer
Difference berween database and data base management system
SQL
0 vote113 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
0 vote104 views1 answer
Psql store procedure-return multiple table values
SQL
4 votes104 views3 answers
Mysql update with join
SQL
0 vote104 views1 answer
Turnicate in mysql
SQL