Posted by Hermes on 05/17/07 16:25

I have a statement in my code;
Sum(CASE WHEN Rcv > 0 and Rcv < 100 THEN Rcv ELSE 0 END) as D100

It gives me a different number if I just add an "=" sign regarding the
0;
Sum(CASE WHEN Rcv > = 0 and Rcv < 100 THEN Rcv ELSE 0 END) as D100

Does anyone know why this would happen?

[Back to original message]