How to truncate a value

• ramadesai108

  SSChampion

  Points: 10609

  More actions

  November 11, 2008 at 1:08 pm

  #202615

  Hi All,

  The following query produces "91.00000000%" value

  select CAST(ROUND((((971 - 90)/(971 * 1.0))

  * 100),0) AS VARCHAR) + '%'

  How do I truncate that value to "91.00%"

  Thanks.

• ljun100

  Grasshopper

  Points: 15

  More actions

  November 11, 2008 at 7:11 pm

  #897267

  SELECT CAST( CAST( ROUND((((971 - 90)/(971 * 1.0)) * 100),0) AS DECIMAL(9,2)) AS VARCHAR) + '%'

• Goldie Lesser

  SSCertifiable

  Points: 6155

  More actions

  November 11, 2008 at 7:43 pm

  #897276

  This type of formatting is better done in your front end application.