title: How to reference the last digits of a column value in SQL
body: <p>I'm trying to select rows from a table only if the last digit of a particular column value is not zero.</p>
  
  <pre><code>SELECT *  
  FROM #table  
  WHERE RIGHT(column, 1) BETWEEN 1 AND 9 
  </code></pre>
  
  <p>is not returning the correct values. I think it's because the data is stored as a string in scientific notation. Please help!<br>
  UPDATE: fixed it! it turned out to be a problem with the data type</p>