percentage format question in T-SQL

• barsuk

  SSChampion

  Points: 12280

  More actions

  March 23, 2004 at 5:00 pm

  #107488

  Hello All,

  What would be the best approach to tackle the following:

  I am getting a number from Database. I need to format it so  it would appear as percentage.

  Ex: if I get 58 then it should look like 5.80

       if I get 120 then it should look like 12.00

       if  I get 5 then it should look like 0.50.

  I am using SQL 7, so  I cannot use UDF. (And I cannot format it on the front end)

  I feel that  I need to write a lot of Case statements??..

  Please let me know.

• wz700

  SSCertifiable

  Points: 7133

  More actions

  March 23, 2004 at 5:55 pm

  #500138

  convert or cast in decimal data type.

  something like convert(decimal(6,2), column/10.0)

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 23, 2004 at 5:57 pm

  #500139

  Use will work and is considered better syntax than convert. Same thing basically thou.

   

  CAST((value / 10.0) AS NUMERIC(10,2))