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

4 votes253 views3 answers
Sqlite show columns
SQL
35 votes292 views5 answers
Sql alter column
SQL
0 vote262 views2 answers
Get top 1 row of each group
SQL
0 vote268 views1 answer
How much space does sql server take per row
SQL
0 vote263 views1 answer
Varchar2 length in oracle
SQL
2 votes274 views1 answer
Show max_allowed_packet mysql
SQL
1 vote292 views1 answer
Nvl postgres
SQL
0 vote268 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
3 votes298 views1 answer
Mysql group_concat distinct
SQL
1 vote257 views1 answer
Sqlite show columns in table
SQL