Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2007
    Posts
    38

    Unanswered: How to add decimals for a field

    Hi all,

    I have a field amount which is of datatype decmal(8,2).
    My problem is, for example 27.09(original value) its showing 2709 in the table for all the records.
    Actually I got a txt file in which the record is 2709, so when I loaded it, its showing 2709 instead of 27.09.

    Can someone tell me how to do bring it to 27.09? plzzz ASAP

  2. #2
    Join Date
    Dec 2005
    Posts
    273
    UPDATE table
    SET column = column / 100 ; ...

  3. #3
    Join Date
    Nov 2007
    Posts
    38
    Thanks dude. Didnt strike me Thank you very much

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •