I am running a SELECT statement and would like to replace a value in the result set.
The value that is being replaced is an integer and the result will be a string.
Here is an example of the statement:
WHEN [Supervisor ID] = '5' THEN 'John'
ELSE [Supervisor ID]
END AS Supervisor, SSN, Salary
Here is the error:
Conversion failed when converting the varchar value 'John' to data type int.
How do I write this?