Sreekumar P
Sreekumar P

Reputation: 6050

sql server remove trailing zeros in decimal

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?

Upvotes: 2

Views: 9945

Answers (0)

Related Questions