SELECT CASE value to evaluate
WHEN literal value 1 THEN return value
WHEN literal value 2 THEN return value
...
END
10>
11>
12> DECLARE @Status Int
13> SET @Status = 1
14> SELECT CASE @Status
15> WHEN 1 THEN 'Active'
16> WHEN 2 THEN 'Inactive'
17> WHEN 3 THEN 'Pending'
18> END
19> GO
--------
Active
(1 rows affected)