I am using Microsoft SQL Server Management Studio 2008. With the query below I am getting this error:
Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the varchar value 'Red' to data type int.
SELECT
CAST(CASE COLORS
WHEN 0 THEN 'Pink'
WHEN 1 THEN 'Yellow'
WHEN 2 THEN 'Red'
WHEN 3 THEN 'Blue'
ELSE TABLE_TEST
END AS varchar(20)) AS Color_Labels
I just need a way to change the numbers to colors. Thank you for your help!
Msg 245, Level 16, State 1, Line 1
Posted - 03/29/2012 : 14:08:38
