Remove trailing zeros from decimal in SQL Server

by

A decimal(9,6) stores 6 digits on the right side of the comma. Whether to display trailing zeroes or not is a formatting decision, usually implemented on the client side.

But since SSMS formats float without trailing zeros, you can remove trailing zeroes by casting the decimal to a float:

select 
    cast(123.4567 as DECIMAL(9,6))
,   cast(cast(123.4567 as DECIMAL(9,6)) as float)

prints:

123.456700  123,4567

(My decimal separator is a comma, yet SSMS formats decimal with a dot. Apparently a known issue.)

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Is it possible to write single query on two table which are not connected to each other?
  3. Can I Comma Delimit Multiple Rows Into One Column? [duplicate]
  4. Multiple INSERT statements vs. single INSERT with multiple VALUES
  5. Split function equivalent in T-SQL?
  6. Is the NOLOCK (Sql Server hint) bad practice?
  7. Is having an ‘OR’ in an INNER JOIN condition a bad idea?
  8. Where value in column containing comma delimited values
  9. How to update Identity Column in SQL Server?
  10. SQL query to split column data into rows
  11. Common Table Expression, why semicolon?
  12. T-SQL split string based on delimiter
  13. Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)
  14. Splitting delimited values in a SQL column into multiple rows
  15. Select a Column in SQL not in Group By
  16. Procedure or function !!! has too many arguments specified
  17. SQL “between” not inclusive
  18. How to efficiently delete rows while NOT using Truncate Table in a 500,000+ rows table
  19. Can I set ignore_dup_key on for a primary key?
  20. Using PIVOT in SQL Server 2008
  21. Stored procedure that exports data into csv files only exports to one file
  22. Do clustered indexes have to be unique?
  23. How do I prevent a database trigger from recursing?
  24. How to combine results of two queries into a single dataset
  25. When using GETDATE() in many places, is it better to use a variable?
  26. Executing SQL Server Agent Job from a stored procedure and returning job result
  27. SQL take just the numeric values from a varchar
  28. Cumulative Total in MS Sql server [duplicate]
  29. Flattening of a 1 row table into a key-value pair table
  30. SQL Server equivalent of WM_CONCAT function [duplicate]

Leave a Comment