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

• LinksUp

  SSCertifiable

  Points: 6526

  More actions

  March 16, 2014 at 9:32 pm

  #1697540

  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

  March 16, 2014 at 10:46 pm

  #1697544

  Thanks LinksUp

• ChrisM@Work

  SSC Guru

  Points: 186127

  More actions

  March 17, 2014 at 5:39 am

  #1697596

  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

  March 18, 2014 at 11:55 pm

  #1698247

  Thanks for your responses.