CASE expression in a Query in SQL Server

Published on August 23, 2016 by Senthil Kumar

Filed under SQL Server

Last modified August 23, 2016

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 7029 times

You can use the CASE expression in a T-SQL query in SQL Server to get the same behavior of the switch statement in the programming languages.

Below is a sample Query demonstrating the implementation of the CASE expression in a query in SQL Server.

use AdventureWorks2014
SELECT Name, GroupName,     
CASE GroupName      
WHEN 'Research and Development' THEN 'United States of America'      
WHEN 'Quality Assurance' THEN 'United Kingdom'          
ELSE 'India'     
END AS Country  
FROM HumanResources.Department

The query associates a Department group name to a country USA and UK for Research and Development and Quality Assurance. For other departments , it associates the country India.


Leave a Comment


You might be Interested in these Posts

C Program to find the G.C.D of a number using Recursive function

Problem Write a program in C to find the find the G.C.D of a number using recursion and display the ...

C Program to print a Half Pyramid using *

Problem Write a program in C to print Half pyramid using * as shown. * * * * * * * * * * ...

C Program to display Positive factors of a number

Problem Write a program in C to display all the positive factors of a number enter by the user. Ho...