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

0 vote257 views2 answers
Create new table plsql
SQL
0 vote272 views1 answer
Mysql subdate
SQL
11 votes274 views1 answer
Oracle insert into where
SQL
1 vote264 views1 answer
Oracle grant on all tables in schema
SQL
0 vote259 views1 answer
Components/Fields of Internal Table
SQL
0 vote267 views1 answer
Mysql filter based on datediff
SQL
0 vote283 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote239 views1 answer
Linux upload database to mysql
SQL
0 vote280 views1 answer
Get current date data in mysql
SQL
13 votes295 views4 answers
What is sql
SQL