Modify the column data

• SQL Prog

  SSCrazy

  Points: 2020

  More actions

  January 10, 2012 at 12:59 pm

  #249319

  Hello All,

  I have a column in a table which holds the amount. Right now the data is like this

  5000.00

  1234.00

  200.00

  I want to update this data to

  50

  12.34

  20.00

  How to achieve this?.

  Thanks for any help

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  January 10, 2012 at 1:11 pm

  #1431376

  Do you mean that you want to take all data to a two digit value? What do you do with 1.5 or 0.6? I assume that 20000 becomes 200, or 20?