SQL Server – Power of CASE function

Case statement can be used to introduce conditional logic. Case statement can be used to evaluate multiple statements and return one possible output. Case can be compared to Switch statement in modern programming languages like C#.