title: SQL Server Bitwise Processing like C# Enum Flags
body: <p>How can one use in SQL Server the processing of the Flags such as on enums in C#?</p>
  
  <hr>
  
  <p>For example, how would one return a list of users that are part of a list or conditions like so:</p>
  
  <pre><code>ConditionAlpha = 2
  ConditionBeta  = 4
  ConditionGamma = 8
  </code></pre>
  
  <p>...</p>
  
  <p>Then there will be users with some of these conditions against them like so:</p>
  
  <pre><code>User1: 6 (conditions Alpha and Beta)
  User2: 4 (condition Beta)
  User3: 14 (conditions Alpha, Beta and Gamma)
  </code></pre>
  
  <p>...</p>
  
  <p>We want to be able to do a query where we say get all users with the first condition Alpha and in this scenario it would return users 1 and 3 even though they have other conditions as well.</p>