Articles → SQL SERVER → Case statement in SQL server

Case statement in SQL server

In this article, we will discuss case statements in SQL server.

What is the case statement?

Case statements are conditional statements where the value of a column (or a variable) is matched with the set of values. Once the value is matched then corresponding value is returned.

Syntax

Case When <condition> then <value_to_be_returned_if_condition_is_satisfied> Else <value_to_be_returned_if_condition_is_not_satisfied> End

Example

Consider an example where I have an Image table with the following schema

Click to Enlarge

For this example, I have added 2 values inside the table

Click to Enlarge

Now our requirement is, if there is any value in the Photo column then return ‘Exists’ else ‘Not Exists’. So the query would be

Select (Case When Photo is not Null then 'Exists' Else 'Not Exists' End) From [Image]

Once you run the above query, you will get following output

Picture showing output of case statement in SQL server

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Tuesday, July 18, 2017

Query/Feedback

Your Email Id

Subject

Query/Feedback	Characters remaining 250