This is what you want to get you going. The & is a bitwise operator to decipher the bitmask for security.

SELECT

      so.name

    , su.name

    , CASE WHEN xtype...