HOW TO view 'real' field not in "xxx.xxExx"style

• netdog

  SSC Enthusiast

  Points: 136

  More actions

  December 14, 2003 at 7:42 pm

  #83101

  I create a table,has a field "cost" real style.when I browse the table IN QA,the field as "1.71E7" but I want to it as "17100000.0" how can do ?

• wz700

  SSCertifiable

  Points: 7133

  More actions

  December 14, 2003 at 10:03 pm

  #486091

  convert(decimal(12,1))

• netdog

  SSC Enthusiast

  Points: 136

  More actions

  December 14, 2003 at 10:42 pm

  #486098

  Thanks for reply.