Use Select Case In SQL Server

In Sql Server you can use Select Case for select data from table
bye use Select Case. It is importance to use because you can used it
for select data that have complicate condition.

Please see example as below:

SELECT title, price,
Budget = CASE price
WHEN price > 20.00 THEN 'Expensive'
WHEN price BETWEEN 10.00 AND 19.99 THEN 'Moderate'
WHEN price <>
ELSE 'Unknown'
END,
FROM titles

In this example, price is a condition that we want to show Message by quality of price