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