Can I have a CASE Statement in the WHERE ... - Essential SQL
According to MS SQL Docs, a CASE statement can be used throughout the SELECT statement. CASE can be used in any statement or clause that allows a valid expression. For example, you can use CASE in statements such as SELECT, UPDATE, DELETE and SET, and in clauses such as select_list, IN, WHERE, ORDER BY, and HAVING.
DA: 48 PA: 61 MOZ Rank: 47