Data type for percent value

• mtraore08

  Right there with Babe

  Points: 771

  More actions

  June 30, 2011 at 3:53 am

  #243090

  Hi Experts,

  I would like to define a data type in table for saving percent value. For instance a valuesuch as 0.96 or 0.96% which data type will fit?

  Thanks

  mtraore

• Paul White

  SSC Guru

  Points: 150467

  More actions

  June 30, 2011 at 3:57 am

  #1346410

  DECIMAL(5,2)

  Paul White
  SQLPerformance.com
  SQLkiwi blog
  @SQL_Kiwi

• mtraore08

  Right there with Babe

  Points: 771

  More actions

  June 30, 2011 at 6:21 am

  #1346471

  Many Thanks