Simple Case Statement Example

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