Results 1 to 2 of 2

Thread: significant digits

  1. #1
    Join Date
    Jun 2007
    Posts
    6

    significant digits

    I have a table that needs to have the significant digits formatted in a certain way. I wrote some code to do just that and it works, but when i look at the table, any zeroes, after a non zero, will be removed from my number although i may want to keep them. For example, take the number 0.25. I want to format it so that it has 3 sig digits such as 0.250. My code will add the last zero, but back in the table it removes it. Is there a way to prevent this or a fix for this kind of problem?
    Thanks

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    store the data in char/varchar format instead of numeric or decimal.

Posting Permissions

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