Hello,
I was wondering if there is any way to implement a binary number type and
allow binary math functions (xor, and, or, etc.) on that data in queries etc.
Specifically what I'm trying to do is store what departments an employee
works in (can be in multiple departments) and store that in a small amount
of space (16 departments could be 16 bit = 2bytes) and binary xor could be
used to create masks to easily return people in particular sets of
departments... I also have other uses for this as well.
I don't think that binary data and operations are part of any specific
SQL standard so I don't know if there would be any hope of getting support
for this added if it isn't currently supported?
-Doug Younger
Programmer, MindSpring Enterprises
"Any sufficiently advanced technology is indistinguishable from magic"
-> Arthur C. Clarke