Case Function in Sql

Case Function

1. Case Function is used to search within row and give desired out instead of searched word

Example:
Select ( Case Column_name When Condition Then Desired_output) as 'New Column Name' from table