title: How to remove trailing zeros from decimal number in SQL Server?
body: <p>How can I remove trailinging zeros from decimal number in SQL Server? 
  If I have as percentage field in database with value as 96.86, my query should return 96.86, but if the value is 96.00 then i need to fetch only 96. How can this be done?</p>