SQL Server: CASE with different clause Using CASE with variable/SET, SELECT/UPDATE statement, WHERE clause, JOIN & ON clause Click here to read the article