Articles → SQL SERVER → Case Statement In SQL Server

Case Statement In SQL Server

In this article, we will discuss case statements in the 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 the 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 we have an "Image" table with the following schema.

Click to Enlarge

For this example, I have added 2 values to the table.

Click to Enlarge

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