Case statement in SQL Server 2008

In this post we will discuss about how to use case statement in sql server 2008.

You can also check my previous posts on:
- asp.net mvc 4 tutorial

- Forms Authentication in Asp.Net

- Method Overloading in C#.Net

Syntax:

CASE expression
WHEN expression1 THEN expression1
[[WHEN expression2 THEN expression2] [...]]
[ELSE expressionN]
END

Example:
select Case Gender when 0 then 'Male' else 'Female' end as Gender from UserMaster where UserID=1

The above query will return Male of Gender field is 0 else it return Female.

Also Check below example where you can have multiple WHEN statements:

select SiteURL,SiteName =
      CASE SiteID
         WHEN 1 THEN 'EnjoySharePoint.com'
         WHEN 2 THEN 'AspDotNetHelp.Com'
         WHEN 3 THEN 'Fewlines4Biju.com'      
         ELSE 'No Site Available'
      END from WebSite