Declare @val int;set @val = 3;Select case(@val) when 1 then 'One' when 2 then 'Two' when 3 then 'Three' else 'Not a number in the range' end as Number_Text
Login to post response