sql server remove trailing zeros in decimal

Question

Is there an easy way to strip trailing 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

Duplicate: http://stackoverflow.com/questions/2938296/remove-trailing-zeros-from-decimal-in-sql-server — Kashif, Oct 21 '10 at 07:21

score 2 · Accepted Answer · edited May 23 '17 at 12:11

2

edited May 23 '17 at 12:11

Community

answered Oct 21 '10 at 07:20

Kashif

1 Answers1