Consider you have table Say TblEmployee with a column say EmployeeName which contain Records as A,B,A,A,B,C,B,C,A your task is to write a query which will change the EmployeeName A to B and B to A.

update TblEmployee set EmpName = EmpName=’A’ THEN ‘B’
WHEN EmpName=’B’ THEN ‘A’
ELSE EmpName
END

You all have entered correct

CREATE table #TbleEmployee (EmployeeName varchar(10)) insert into #TbleEmployee(EmployeeName) VALUES('A'), ('B'), ('A'), ('A'), ('B'), ('C'), ('B'), ('C'), ('A') update #TbleEmployee SET EmployeeName=(CASE EmployeeName WHEN 'A' THEN 'B' WHEN 'B' THEN 'A' ELSE EmployeeName END)

Dasharath Vishwakarma12y

update TblEmployee
set EmpName = (CASE
WHEN EmpName='A' THEN 'B'

WHEN EmpName='B' THEN 'A'

ELSE EmpName
END)

Sukesh Marla14y

Consider you have table Say TblEmployee with a column say EmployeeName which contain Records as A,B,A,A,B,C,B,C,A your task is to write a query which will change the EmployeeName A to B and B to A.

4 Answers