title: How Can I determine is digit Even number?
body: <p>Bit rusty on the old sql.</p>
  
  <p>Can you help?</p>
  
  <p>Given a number eg 1 or 2 or 4 I need to determine if it's even or odd number and do some calculation 
  depending if even or odd .</p>
  
  <p>How do you detect that in sql (sql server 2000)
  thanks a lot</p>