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

6 votes366 views1 answer
Oracle trigger after logon on schema
SQL
2 votes352 views1 answer
Sql server find table name
SQL
0 vote367 views1 answer
Using distinct and count together in sql
SQL
12 votes359 views5 answers
Sql merge
SQL
0 vote357 views1 answer
Case when with count and combining similar values in sql
SQL
2 votes352 views1 answer
Sql skip the first row
SQL
0 vote351 views1 answer
Sql select first and last record of each group
SQL
0 vote367 views1 answer
Table or view does not exist
SQL
2 votes375 views2 answers
Sql query to copy data from one column to another
SQL
1 vote367 views1 answer
Sql select all from one table and one column from another
SQL