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

1 vote322 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
0 vote277 views1 answer
How to check oracle index table
SQL
0 vote350 views4 answers
Open mysql port bitnami tomact
SQL
0 vote317 views1 answer
Oracle show running job
SQL
0 vote352 views1 answer
How to install sql in anaconda
SQL
0 vote414 views1 answer
TSQL Find csv file in folder
SQL
6 votes334 views3 answers
Update with inner join postgres
SQL
8 votes335 views2 answers
Alert table name mysql
SQL
1 vote337 views1 answer
Wordpress change http to https phpmyadmin
SQL
0 vote318 views1 answer
Sum value by month sql
SQL