Dang! I just implemented some bitmapped stuff in SQL Server 2019, and I had to write similar functions myself. It will be a while before the non-profit I work for can swing the upgrade to SQL Server 2022. That does seem pretty cool to have
... WHERE GET_BIT(FlagColumn, 3) = 1
But I have found that
... WHERE FlagColumn & 8 = 8
is pretty fast.
- This reply was modified 1 month, 1 week ago by JediSQL. Reason: missed a couple words