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
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