Damon: No database where I have control over the design ever uses Real. I always use Double. If you care about the accuracy of a number with decimals, use either Real or Numeric. If I can, I will change the definition of existing columns to go to Double.
What you see in the display of a Real number is not how it's actually stored.... Just my opinion, doesn't help you at all! Karen > Let’s suppose we have a table with a REAL and an INT, and let’s lay it > out left to right as below: > > > > REAL1 INT1 > > .0599 NULL > > .0600 NULL > > .0601 NULL > > .0698 NULL > > .0699 NULL > > .0700 NULL > > .0701 NULL > > > > Now, let’s use the update command to set INT1 to the value of REAL1 * > 10000. What would you expect? Well, I expect something other than what I’m > getting. The results are as follows: > > > > REAL1 INT1 > > .0599 599 > > .0600 599 > > .0601 601 > > .0698 697 > > .0699 698 > > .0700 700 > > .0701 701 > > > > What gives?? > > > > > > wwwww > > ( @ @ ) > > -------oOO---(_)---OOo------- > > Damon J. Gray > > >
