title: Drop 0 value in decimal places
body: <p>I want to ask if anybody know the query to drop the 0 value in decimal..</p>
  
  <p>E.g : A field name percent have these values</p>
  
  <h2>Percent</h2>
  
  <p>770.00000000000000000000,
  340.670000000000000000000,
  96.00000000000000000000,
  4400.56000000000000000000,
  109.89000000000000000000,
  109.00000000000000000000,
  37.00000000000000000000,</p>
  
  <p>Currently I'm using the query "select cast([Percent] as decimal(9,2)) as [Percent] from table" and will result in</p>
  
  <h2>Result</h2>
  
  <p>770.00,
  340.67,
  96.00,
  4400.56,
  109.89,
  109.00,
  37.00,</p>
  
  <p>I want the result this actually:-></p>
  
  <p>770,
  340.67,
  96,
  4400.56,
  109.89,
  109,
  37,</p>