Posted by --CELKO-- on 12/23/06 20:24

>> I want to run queries on a table that has binary fields [sic] in it.<<

Fields and columns are totally different concepts. If you knew that,
you would not use low-level physical concepts like a binary field in an
SQL database. SQL is based on higher level abstractions. It also uses
a concept called "Normal Forms" that you need to learn; that means that
every column is a scalar value. That means that the bits in the
physical implementation have no meaning in themselves.

>> How do I filter on a binary field? <<

With propriertary, hardware dependent (high end or low end? ones or
twos complement math? how big is a word? etc.) kludges or with
unreadable math expressions, like all bad programmers!

[Back to original message]