Remove trailing zeros from decimal in SQL Server
Posted
by abatishchev
on Stack Overflow
See other posts from Stack Overflow
or by abatishchev
Published on 2010-05-30T10:56:45Z
Indexed on
2010/05/30
11:02 UTC
Read the original article
Hit count: 204
I have a column DECIMAL(9,6)
i.e. it supports values like 999,123456.
But when I insert data like 123,4567 it becomes 123,456700
How to remove those zeros?
© Stack Overflow or respective owner