Thursday, February 4, 2016

SQL Server SELECT CASE and convert in VARCHAR


numberValue  is an number

SELECT CASE numberValue 
                        WHEN 1 THEN 'State 1'
                        WHEN 2 THEN 'State 2'
                        WHEN 3 THEN 'State 3'
                        ELSE CAST (numberValue AS VARCHAR(50))



No comments:

Post a Comment