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
- Remove trailing zeros from decimal in SQL Server
- Add Trailing Zeroes After Decimal
- Remove some of trailing zeros from decimal
- Formatting decimal leading with zeros
- SQL Server : remove trailing 0's after decimal point. nvarchar datatype
- Remove the trailing zeros after Decimal points without truncating/ approximating the value in SQL server
- How to remove trailing zeros from decimal number in SQL Server?
- Remove trailing zero from decimal number
- SQL server removing traling zero after decimal points in a string
- How can I remove trailing and leading zeroes then convert to a decimal without rounding