Use if-else logic in where where in T-SQL

Question

Is there a way to use if-else logic in the where clause in T-SQL? or do I need to implement logic using a subquery?

Answer 1

Use Case

(case foo when bar then baz else fizz end)

Answer 2

You can use the case statement in the where clause, but it can cause performance problems, so you can try a different approach if you have a large dataset. A correlated subquery would not be a good alternative approach; view or CTE may be.