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

2 votes275 views1 answer
Tsql copy table
SQL
0 vote170 views1 answer
My sql data file extention
SQL
0 vote178 views1 answer
Create-table-with-index-organization
SQL
1 vote213 views1 answer
Is sql fast
SQL
2 votes192 views1 answer
Find column in all stored procedures sql server
SQL
0 vote225 views1 answer
Mssql describe stored procedure sqlcmd
SQL
1 vote180 views1 answer
Raw query must include primary key
SQL
1 vote159 views1 answer
Mysql server does not start mac
SQL
0 vote182 views1 answer
T sql dynamic top n query
SQL
0 vote197 views1 answer
Create a plsql object
SQL