title: Purpose of modulo operator in SQL statement
body: <p>For a list of CustomerID's that are ranging from 1 through to 40000 what action is the WHERE clause performing when combined with the modulo operator?</p>
  
  <p>Is this statment effectively saying 'Where the CustomerID (e.g. 30115) is divided by 7 and gives a remainder of 1 then set the EmailAddress to NULL'?</p>
  
  <pre><code>UPDATE SalesLT.Customer
  SET EmailAddress = NULL
  WHERE CustomerID % 7 = 1;
  </code></pre>