title: Select rows where column value starts with a string AND ends with an even number
body: <p>This is in an Oracle DB: </p>
  
  <p>I need to return the values from a column that start with a specific string AND end with an even (then odd) number.<br>
  For example:</p>
  
  <pre><code>ABC001
  DEF001
  ABD001
  ABD002
  OPQ001
  ABD003
  ABD004
  </code></pre>
  
  <p>I need a query that returns ONLY ABD002 and ABD004.</p>
  
  <p>The last 3 characters of the string are always numeric, if that helps. </p>