how to remove trailing zeros?

• water490

  Ten Centuries

  Points: 1051

  More actions

  February 29, 2024 at 9:51 pm

  Go to Answer

  #4387262

  I have this calculation I have in a script:

  ROUND(T3.NUM_POINTS * 1.0 / T4.TOTAL_RECORDS * 100,2) AS NUM_POINTS_PERCENT,

  It produces this:

  0.820000000000

  I only want 2 decimals to be displayed so the answer should be 0.82.  Another example,

  0.900000000000

  This should be 0.90

  How can I modify the format so the unneeded zeros are removed?

  Thank you

  • This topic was modified 1 year, 3 months ago by water490.

• pietlinden

  SSC Guru

  Points: 63573

  More actions

  March 1, 2024 at 12:13 am

  Answer

  #4387306

  Cast as Decimal?

  SELECT CAST(154399.234 AS DECIMAL(17,2));

• water490

  Ten Centuries

  Points: 1051

  More actions

  March 1, 2024 at 12:20 am

  #4387307

  thank you it worked!