sql server remove trailing zeros in decimal

Is there an easy way to strip traili开发者_开发技巧ng zeros from decimals so that

select amount from table

gives you 2.5 instead of 2.50 or 3 instead of 3.00?

Thanks,

Tom

---

remove-trailing-zeros-from-decimal-in-sql-server