CASE expression in a Query in SQL Server

Published on August 23, 2016 by abundantcode

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


If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Comment


You might be Interested in these Posts

Displaying all the worksheet names in Excel using VBA Code

Do you want to display the names of the worksheets in the excel workbook ?. Here;s how you can do it...

How to change positive numbers to negative in Microsoft Excel 2016 ?

Do you want to change the positive numbers to negative numbers and vice versa (or in simple terms) ,...

How to convert number to text in Excel?

In Microsoft Excel 2016 , there are times when you don't want the numbers present in the cell to be ...