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 and Method Overloading in C#.Net.
WHEN expression1 THEN expression1
[[WHEN expression2 THEN expression2] […]]
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 =
WHEN 1 THEN ‘EnjoySharePoint.com’
WHEN 2 THEN ‘AspDotNetHelp.Com’
WHEN 3 THEN ‘Fewlines4Biju.com’
ELSE ‘No Site Available’
END from WebSite