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
update TblEmployee set EmpName = EmpName=’A’ THEN ‘B’WHEN EmpName=’B’ THEN ‘A’ELSE EmpNameEND