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 votes297 views1 answer
Sql finding longest and shortest names in a fleld
SQL
1 vote285 views1 answer
Float precision in psql
SQL
0 vote291 views1 answer
Oracle current timestamp
SQL
4 votes285 views3 answers
Oracle sql first day of quarter
SQL
0 vote304 views1 answer
Search from comma separated values in sql server
SQL
21 votes296 views6 answers
Change column in mysql
SQL
0 vote282 views1 answer
Partitioning in oracle-base
SQL
1 vote303 views1 answer
What is a Database?
SQL
0 vote264 views1 answer
Install mysql 8 linux
SQL
0 vote300 views2 answers
Oracle create tablespace autoextend
SQL