I'm not sure what you're looking to do, but have you tried setting the precision at
all?
float and real
Approximate number data types for use with floating point numeric data. Floating point
data is approximate; not all
values in the data type range can be precisely represented.
Syntax
float [ ( n ) ]
Is a floating point number data from - 1.79E + 308 through 1.79E + 308. n is the
number of bits used to store the
mantissa of the float number in scientific notation and thus dictates the precision
and storage size. n must be a value
from 1 through 53.
n is Precision Storage size
1-24 7 digits 4 bytes
25-53 15 digits 8 bytes
The Microsoft� SQL ServerT float[(n)] data type conforms to the SQL-92 standard for
all values of n from 1 to 53. The
synonym for double precision is float(53).
----- Original Message -----
From: "Hugo Ahlenius" <[EMAIL PROTECTED]>
> Hi,
>
> I have values stored as "float" in an MSSQL2k table. If i store "55.5" as
> a value in this column, I sometimes get back "55.500000000000" (a lot of
> decimals). And sometimes "55" returns "55.0". (returns = cfquery)
>
> Any hints tips, references for some RTFM?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
