http://www2.sqlblog.com/blogs/adam_machanic/archive/2006/07/12/bitmask-handling-part-2-bitmask-reconstitution.aspxPosting the first part of my series on bitmasks (yes, this is now officially a series) taught me a lot about my readers: You don't care about handling bitmasks in the database. And I respect you for that! I'm overjoyed, as a matter of fact! That articleenCommunityServer 2.1 SP2 (Build: 61129.1)http://www2.sqlblog.com/blogs/adam_machanic/archive/2006/07/12/bitmask-handling-part-2-bitmask-reconstitution.aspx#12438Thu, 05 Mar 2009 13:25:50 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:12438Tim<p>I know you probably don't monitor this anymore, but I wanted to try these articles for &quot;fun&quot;. &nbsp;However, after generating my numbers table exactly the way you did, I am getting completely different results for all the above statements. &nbsp;As a matter of fact, all the &quot;TotalValue&quot; results come back the exact opposite of what you have:</p> <p>In your 3rd statement for example, I get:</p> <p>Byte TotalValue</p> <p>3 0xF3</p> <p>2 0x01</p> <p>1 0x10</p> <p>What am I doing wrong?</p> http://www2.sqlblog.com/blogs/adam_machanic/archive/2006/07/12/bitmask-handling-part-2-bitmask-reconstitution.aspx#12439Thu, 05 Mar 2009 14:11:21 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:12439Tim<p>Ha! &nbsp;Nevermind, I didn't read the other post about the fix to the splitBitmask function...</p>