Sql case update

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 vote180 views1 answer
Pl sql search saurce code
SQL
3 votes183 views4 answers
Show databases in sql server
SQL
2 votes182 views2 answers
Mysql get time from datetime
SQL
-1 vote180 views1 answer
Ssql to lowercqse
SQL
0 vote226 views1 answer
Selecting Multiple Columns in SQL
SQL
0 vote185 views1 answer
QUERY JPQL
SQL
0 vote191 views1 answer
Uncheck constraints and delete from table
SQL
3 votes150 views2 answers
Coalesce mysql
SQL
0 vote171 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
15 votes188 views2 answers
Sql order by multiple columns
SQL