title: How to create a column for even and odd records dynamically?
body: <p>I have a query in Teradata. I want to add an additional column that would be a VARCHAR.
  It should say whether the selected record is even or odd</p>
  
  <pre><code>select id, name, CASE newColumn WHEN  --- ???
  from my table
  </code></pre>
  
  <p>Like this</p>
  
  <pre><code>id  name     newColumn
  1   asdf     odd
  2   ts df    even
  32  htssdf   odd
  4   asdfsd   even
  23  gftht    odd
  </code></pre>
  
  <p>How can I do this</p>