sql server replication - how to get combination of values from a binary(8) field?
Use the built-in bitwise operators to examine the column.  For example

select
    schema_option &amp; 0x01 AS  GeneratesObjectCreation,
    schema_option &amp; 0x02 AS  GenerateCustomSP,
... etc.