Use a numeric datatype. In Oracle, number(7,6), SQL server is something
similar. The first digit inside the parenthesis is the number of
significant digits, the second number is the number of digits after the
decimal. If you data is >= 0 and <= 1 this will work, assuming you only
need six decimals.
-dhs
At 12:34 PM 9/25/01 +0100, you wrote:
>I am bulk inserting a file into my database that contains the column 'cost'
>
>The column has the following values:
>0.113333
>0.0105
>0.02178
>0.040333
>0.028022
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
