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 vote165 views1 answer
Android sqlite get rows count
SQL
0 vote162 views1 answer
Oracle sql log to console
SQL
0 vote176 views2 answers
How to find max and min salary in sql
SQL
31 votes172 views3 answers
SQL Server change column data type
SQL
0 vote259 views1 answer
How to get table current identity value in sql server
SQL
1 vote164 views2 answers
Oracle difference between two dates in seconds
SQL
3 votes178 views1 answer
Increment integer in table sql
SQL
1 vote183 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
6 votes191 views1 answer
To count number of rows in SQL table
SQL
0 vote222 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL