0.0105 is being shown as -3.42149
The column is set to precision 18, scale 6, length 9
> -----Original Message-----
> From: Dean H. Saxe [mailto:[EMAIL PROTECTED]]
> Sent: 25 September 2001 13:31
> To: SQL
> Subject: Re: Data type conversion
>
>
> Use a numeric data type. 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
