How do I convert to a percentage?

• smithsp17

  Mr or Mrs. 500

  Points: 515

  More actions

  November 4, 2009 at 2:51 pm

  #211785

  Hi,

  I'm trying to do some math, then convert the results to a percentage, but I come up with 0. Here's the select:

  select CONVERT(varchar,((76075/119027) *100)) + ' %' from master.sys.databases where database_id=1

  The above should show me 63.91%, but instead I get 0 %.

  Thanks!

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  November 4, 2009 at 3:03 pm

  #1075067

  You need to use decimal math, instead of integer math.

  select

  Wrong = (76075/119027)*100 ,

  Correct = (76075./119027.)*100.

  Results:

  Wrong Correct

  ----------- ------------------

  0 63.9140600

• smithsp17

  Mr or Mrs. 500

  Points: 515

  More actions

  November 5, 2009 at 10:20 am

  #1075488

  Perfect, thank you!