CASE statement in SQL

[lalitha1]

Can someone help me with this.I am trying to use CASE statement and I get the following error Line 4: Incorrect syntax near '='.

[Select EmpUsr.*,
CASE
When usrkey = adminusrkey then
'AdminName' = fname +' '+Lname
Else when usrkey <> adminusrkey then
'ClientName' = fname +' '+lname
End
From EmpUsr]

 

[RiverGuy]

Are AdminName and ClientName names of columns? What I think you are trying to do is the following. Test it out and let me know if this is what you are looking for:

Select EmpUsr.*,
AdminName =
CASE
  WHEN usrkey = adminusrkey THEN fname +' '+Lname
  ELSE AdminName
END,
ClientName =
CASE
   WHEN usrkey <> adminusrkey THEN fname +' '+Lname
  ELSE ClientName
END
From EmpUsr

Note, in this scenario, you would have to specify each column in the select list so you don't dupe up the AdminName and ClientName columns.

 

[lalitha1]

AdminName and ClientName are not the existing columns in my table.All i have is Fname and lname and if my conditions like usrkey = adminusrkey then fname +lname will be my AdminName else it will be ClientName.

 

[lalitha1]

I made the following changes to your code and it works. Thanks!

[Select Empusr.*,
'AdminName' =
CASE
WHEN usrkey = adminusrkey THEN fname +' '+lname
END,
'ClientName' =
CASE
WHEN usrkey <> adminusrkey THEN fname +' '+Lname
END
From EmpUsr]