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: 201

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

Related posts about sql

Related posts about tsql