• Select

    PartyId,

    FirstName,

    LastName,

    Case when Source&1<>0 then 1 else 0 End[Source1],

    Case when Source&2<>0 then 2 else 0 End[Source2],

    Case when Source&4<>0 then 4 else 0 End[Source3],

    AddDate,

    ModDate

    from dbo.ExistingMaster

    Will you please let me know what Case when Source&1<>0 then 1 else 0 for in this code ?

    Thx.