This article explains the usage of the SQL Case in Where clause with examples when to use the Case statement in SQL Server
