Thanks in advance. I'm new to tsql. I have the following code.
WHEN 1 THEN '1'
WHEN 2 THEN CONVERT(VARCHAR, ' b')
WHEN 3 THEN CONVERT(VARCHAR, ' c')
However I get an error message that says "Conversion failed when converting the varchar value ' c' to data type int