>if you can make the bit-mask a fixed value in the SQL Statement Generally not. It might be possible in a handful of cases but that's more an exception than the rule. The database predates SQLite's bitwise support, but once that was available we starting leveraging it pretty regularly (most tables have at least 1 bitfield, some have multiple). Reworking the design can pose significant impact. I'll consider it (in part or whole), if necessary. But I'm hoping it won't be necesssary