title: MOD operator in where clause
body: <p>I am getting an invalid number exception. How do you use <code>MOD</code> in <code>WHERE</code> clause? I am wanting to update even or odd rows based on ID.</p>
  <pre><code>update employee  set respstr1 = 'EP' where mid = 7246 and (mod(id/2) = 1)
  </code></pre>