title: What is the use of "&" operator in SQL SERVER
body: <p>What is the use of &amp; operator in the code specified below. IS there any benefit of using &amp; instead of "AND". Please elaborate.</p>
  
  <pre><code>CASE ( C.[Status] &amp; F.[Status] &amp; D.[Status] &amp; DWT.[Status] &amp; P.[Status] )
      WHEN 1
          THEN CASE ( C.IsDeleted &amp; F.IsDeleted &amp; D.IsDeleted &amp; P.IsDeleted )
          WHEN 0 THEN NULL
          ELSE 7
          END
      ELSE 6
  END
  </code></pre>