odepriester (9/6/2013)
btw, wouldn't it be better writing your example query more like :
SELECT * FROM t
WHERE (a<>0) and (b= 2 * a)
?
It will avoid the "CASE" term
Sometimes a rewrite like that would work, but if 'a=2' and 'b=5' are integers, then
b/a = 2
but
b <> 2*a