How are you inserting your data? Lets see the SQL...
-dhs
At 02:08 PM 9/25/01 +0100, you wrote:
>I am now getting negative numbers ?
>
> > -----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 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
