removing and adding decimal point

• Ven-712413

  Grasshopper

  Points: 23

  More actions

  April 15, 2008 at 8:32 am

  #186548

  hello.. how do you remove and add decimal point in an sql query statement?

  Example: If you've 25076, 20000, 1298, 123....

  The result: 250.76, 200.00, 12.98, 1.23

  vice versa...

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  April 15, 2008 at 8:39 am

  #802615

  Just divide by 100.0.

  John

• Ven-712413

  Grasshopper

  Points: 23

  More actions

  April 15, 2008 at 9:14 am

  #802639

  Oh... Right!! I didn't think of that! Thanks! 😀

• Ven-712413

  Grasshopper

  Points: 23

  More actions

  April 15, 2008 at 9:24 am

  #802650

  Another is.. how do you trim a string not having the same size?

  Example: I want to remove the 0's..

  00000250

  00001245

  00344667

  Result:

  250

  1245

  344667

  I've tried some sql query functions but it didn't work...

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  April 16, 2008 at 12:53 am

  #802906

  SELECT CAST(MyString AS INTEGER)

  John