Re: bit operations

"Randal L. Schwartz" wrote:
>
> >>>>> "Oliver" == Oliver Vecernik <vecernik@aon.at> writes:
>
> >> Say I wanna check if 8 (1xxx) and 2 (xx1x) is set, how do I do that?!
>
> Oliver> Sorry, I didn't read the whole question first:
>
> Oliver> select * from table where ((flags & 8) <> 0) and ((flags & 2) <> 0);
>
> In the old days, we spelled that as flags & 10 = 10. :)  Wouldn't that
> work just as well?

As far as I know testing for <> 0 could be calculated faster. Does
anybody know if this is true?

Regards,
Oliver