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

1 vote108 views1 answer
Check constraint to check if date greater than todays date
SQL
1 vote116 views3 answers
Psql fatal database does not exist
SQL
0 vote118 views1 answer
Mysql changer nom table
SQL
10 votes114 views5 answers
Between keyword in sql
SQL
0 vote118 views1 answer
Plsql check how much space all databases are consuming
SQL
1 vote133 views1 answer
Insert pg result of select
SQL
6 votes141 views3 answers
What is where in sql
SQL
0 vote285 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote118 views1 answer
Postgresql where clause not working
SQL
0 vote204 views1 answer
Sql change a colum to unique
SQL