Re: bit operations

>>>>> "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?

--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn@stonehenge.com> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!