CREATE table #TbleEmployee (EmployeeName varchar(10))insert into #TbleEmployee(EmployeeName)VALUES('A'),('B'),('A'),('A'),('B'),('C'),('B'),('C'),('A')update #TbleEmployee SETEmployeeName=(CASE EmployeeName WHEN 'A' THEN 'B' WHEN 'B' THEN 'A' ELSE EmployeeName END)
You all have entered correct