> Looking for the best way to query a table with an integer column by value
> of the lower 16 bits of the data in that column. Does SQLite support
> bitwise logic?
Yes. You can use the following
& | ~ << >>
AND OR NOT SHIFTLEFT SHIFTRIGHT
However it is far faster to search for integer values. So if your table has lots of rows and/or you do lots of queries like this, you should consider keeping a copy of the lower 16 bits as another integer column.