SELECT statements with CASE expressions:

Normally when we are working with T-SQL queries we may have scenarios to use CASE expression to filter or filter the data based on conditionals. CASE expressions are very use full to acheive the above.

Eg: Example below gives you the breif idea how to use SELECT with CASE expressions.