SQL CASE statement in WHERE clause without comparison leads to unexpected results. The CASE statement evaluates but doesn't filter as intended.