title: How to remove trailing zeros using Sybase SQL?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/2938296/remove-trailing-zeros-from-decimal-in-sql-server">Remove trailing zeros from decimal in SQL Server</a>  </p>
  </blockquote>
  
  
  
  <p>I have a column DECIMAL(9,6) i.e. it supports values like 999,123456.</p>
  
  <p>But when I insert data like 123,4567 it becomes 123,456700</p>
  
  <p>How to remove those zeros in sybase SQL?</p>
  
  <p>Using <a href="https://stackoverflow.com/questions/2938296/remove-trailing-zeros-from-decimal-in-sql-server">this</a> didn't work!</p>