float or decimal 1

[Gooser]

I need to store a [tt]factor[/tt] which will be multiplied by numbers that will be around the $XX,000,000 range to get a fee based on volume of sales. The factors are very small decimal values between .000025 and .001 which I am currently storing as floats. Is this the right data type? Should I use decimals?

How do I get Query analyzer to return something prettier than [tt]7.7999999999999999E-4[/tt]?

Thanks,

 

[gmmastros]

Float (and Real) are approximate data types. I suggest you change this field to decimal instead.

Looking at the smallest number (.000025) and the largest number (0.001), I recommend...

Decimal(6,6)

The first number represents the total number of digits that can be stored. The second number represents the number of digits AFTER the decimal point.

so.... 12.3456 would require Decimal(6,4).

Make sense?

-George

"the screen with the little boxes in the window." - Moron

 

[Gooser]

George--

You RULE.

Thanks,
--Gooser