title: Removing decimals in SQL Query
body: <p>My question is rather short but I have a issue finding a answer. But I have a select in SQL that has the following search:</p>
  
  <pre><code>Max(CashTrans.Costprice)
  </code></pre>
  
  <p>In my result in SQL I get the following</p>
  
  <pre><code>-1180,00
  -1377,502
  -0,40
  -460,00
  -100,00
  -100,00
  -100,00
  -100,00
  -100,00
  </code></pre>
  
  <p>What is the most effective and easiest way removing "," and all decimals after so the result would end up with </p>
  
  <pre><code>-1180
  -1377
  -0
  -460
  -100
  -100
  -100
  -100
  -100
  </code></pre>
  
  <p>Thanks and have a good day!</p>