Case Statement in SQL Server

This blog defines the case statement with a simple example in SQL Server.

--SQL SERVER – CASE Statement- Simple CASE expressions

declare @condition nvarchar(max)

set @condition=1
select case @condition
when 1 then 'You have 1 Year Expirence'
when 2 then 'You have 2 Year Expirence'
when 3 then 'You have 3 Year Expirence'
when 4 then 'You have 4 Year Expirence'
when 5 then 'You have 5 Year Expirence' 

end

Output