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

2 votes321 views2 answers
Postgresql date at timezone
SQL
3 votes363 views2 answers
Check data in table mysql
SQL
3 votes364 views1 answer
Select count from table mysql
SQL
0 vote332 views1 answer
Create query in where clasue
SQL
3 votes310 views1 answer
Pl sql check if variable is empty
SQL
0 vote345 views1 answer
How to add boolean column in postgresql
SQL
0 vote351 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
0 vote336 views1 answer
Django how to get query result count
SQL
0 vote340 views1 answer
Reona
SQL
0 vote327 views1 answer
Postgress append string in select
SQL