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 vote194 views1 answer
Mysql function variable
SQL
5 votes200 views2 answers
Oracle tables with column name
SQL
0 vote215 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
0 vote158 views1 answer
Check id exist or not in sql
SQL
0 vote213 views2 answers
Get item by composite primary key mysql
SQL
0 vote201 views2 answers
Sql query in dax power bi
SQL
0 vote188 views1 answer
How to know if table in rigt or left in sql
SQL
0 vote202 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
0 vote192 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote196 views1 answer
Python mysql show databases
SQL