title: TSQL error: Operand data type bit is invalid for add operator
body: <p>I am in the process of converting some Access queries into tsql and this error pops up when I try to execute the query.
  I am guessing that SQL Server does not allow adding of 'bit' types, so I found the cultprit lines where that occurs and they are:</p>
  
  <pre><code>SELECT DISTINCT 
     [modules].[b]+[modules].[w]+[modules].[e]+[modules].[j]+
     [modules].[p]+[modules].[s] AS approvalRating, -- other columns here --
  </code></pre>
  
  <p>And:</p>
  
  <pre><code>ORDER BY [modules].[b]+[modules].[w]+[modules].[e]+[modules].[j]+
     [modules].[p]+[modules].[s],
     modulePriority.configPriority, 
     [modulePositionalData].[highPos]-[modulePositionalData].[lowPos]+1, 
     modulePositionalData.iMax;
  </code></pre>
  
  <p>Now I did not create the original Access queries and I have no idea what was the intention of adding that Boolean fields which makes it a bit problematic, but is there a way to allow the operations to be performed and result to be the same as performed by Access?</p>