Corina
You want float.
>From the docs:
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.
Nick
-----Original Message-----
From: Corina Moore [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 9:18 PM
To: SQL
Subject: Exponentials & Data Types
Our users need to be able to enter exponential information.
(ex: 2.63e11)
After they enter the information we need to be able to do calculations on
it (mostly subtracting one exponential from another exponential)
Any have any thoughts on the best data type to handle this.
Thanx...
*********************************
Corina S. Moore
IMDC Software Developer
301-286-6124
http://imdc.nasa.gov
**********************************
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
