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

3 votes135 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
2 votes126 views1 answer
Sql as
SQL
0 vote133 views1 answer
Sql period overlap
SQL
0 vote135 views1 answer
Recursive query herarchical data sql server
SQL
0 vote130 views1 answer
Print mysql
SQL
1 vote128 views1 answer
Oracle lowercase
SQL
5 votes145 views4 answers
Start postgres server
SQL
0 vote143 views1 answer
How to install Firebird
SQL
0 vote125 views1 answer
Check if record exists mysql
SQL
0 vote139 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL