How to remove trailing zeros from a decimal (type) value?

Question

Post reply

How to remove trailing zeros from a decimal (type) value?

david.dartnell

Ten Centuries

Points: 1276
More actions
March 16, 2014 at 7:18 pm

#290927

Hi Everyone,
I would like to 'drop' some trailing zeros from a decimal value, e.g.: 50.000000, and I am wondering how to go about this?
The value is definitely of decimal type, and in this instance I know that I want to eliminate exactly six (6) zeros.
Any help here will be greatly appreciated.
Kind Regards,
David

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

LinksUp SSCertifiable Points: 6526 More actions · Answer 1

Normally you should not care about trailing 0's. The front end worries about the display and making it pretty.

But if you have to, this should do it:

Select cast(100/2.0 as decimal(3))

__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/

david.dartnell Ten Centuries Points: 1276 More actions · Answer 2

david.dartnell

Ten Centuries

Points: 1276

March 16, 2014 at 10:46 pm

#1697544

Thanks LinksUp

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 3

david.dartnell (3/16/2014)
Hi Everyone,
I would like to 'drop' some trailing zeros from a decimal value, e.g.: 50.000000, and I am wondering how to go about this?
The value is definitely of decimal type, and in this instance I know that I want to eliminate exactly six (6) zeros.
Any help here will be greatly appreciated.
Kind Regards,
David

Cast the value to whichever of the integer datatypes is appropriate.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

david.dartnell Ten Centuries Points: 1276 More actions · Answer 4

david.dartnell

Ten Centuries

Points: 1276

March 18, 2014 at 11:55 pm

#1698247

Thanks for your responses.