I don't mean to be crass, but do you understand exponentials?
6.3967454E-6 equates to .0000063967454
In what world would rounding .0000063967454 to 6 make any sense at all?
Either way, you could do what someone else suggested and multiply the number
by 1,000,000, and then round it to get 6.
Zach
Quote:
> What i really need to do is round that Exponential value.
> round(6.3967454E-6,0) gives me zero, whatever i convert
> this number into(float, decimal, etc), i need to get in
> this case 6, if this value was 6.583455E-6 i should get 7.
> All i need to do is implement Round() finction to this
> exponential value, which i can't do....
> >-----Original Message-----
> >The result is a very very small number, not 6.39 or
> anything like
> >that. (Throwing away the E-6 at the end would be
> multiplying the
> >value by one million.)
> >What do you mean "you cannot do" anything with this
> number? In
> >what context? For example if you store it in a Transact-
> SQL
> >variable of type "float" you should be able to work with
> it.
> >> Dividing 2.0/312659.0 gives me 6.3967454E-6
> >> After this point i cannot do any arithmetical operations
> >> with this number!(Exponential Value)
> >> Is there a way to convert the value 6.3967454E-6 into
> >> something like that :6.3967 ?
> >> I know that i can convert 6.3967454E-6 into a varchar,
> cut
> >> and throw away 'E-6' and then convert 6.3967454 into a
> >> decimal again, but i really think that there is
> something
> >> more prettier in SQl SERVER, there is gotta be....
> >.
Exponential Values