title: Remove decimal using SQL query
body: <p>I want to convert my decimal SQL query result in percent. Example I have a 0.295333 I want it to be 30% and if I have a 0.090036 I want it to be 9%. </p>
  
  <p>This is what I have so far.</p>
  
  <pre><code>(100 * (sample1/ sample2) ) as 'Percent'
  </code></pre>
  
  <p>I also tried this one but the problem is result comes with <strong>".00"</strong> and I don't know how to remove the decimal.</p>
  
  <pre><code>cast (ROUND(100 * (sample1 / sample2),0) As int ) as 'Percent'
  </code></pre>