Remove trailing zeros from decimal in SQL Server

C

Costas

Administrator
Staff member
JavaScript: 
-- src    - https://stackoverflow.com/a/18520357
-- ms doc - https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-numeric-format-strings
SELECT FORMAT(CAST(2.33000       AS DECIMAL(9,6)), 'g15')  -- '2.33'
 
You must log in or register to reply here.
Top