|
|
Posted by Roy Harvey on 11/20/06 23:36
On 20 Nov 2006 14:53:34 -0800, mpaine@htxml.com wrote:
>So is PRINT CAST(1 AS float)/(CAST(1 AS float)+CAST(26 AS float)) the
>best way to get the correct answer for PRINT 1/(1+26)?
>
>- Michael
If a value is a constant, simply adding a decimal point to it is
sufficient, and only one of the operators needs the decimal point:
PRINT 1.0/(1+26)
Alternately, if none of the values are constants, converting any one
of them is sufficient. However, I would not choose to convert to
FLOAT, but to an appropriately sized DECIMAL.
PRINT CONVERT(DECIMAL(15,6),1)/(1+26)
Roy Harvey
Beacon Falls, CT
Navigation:
[Reply to this message]
|