The syntax pattern for case : Case « Query « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Query
3. Case

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)