Print without Scientific Notation 
Author Message
 Print without Scientific Notation
How do I display 1112620 instead of 1.11262e+006?




Result:
1.11262e+006

Thanks,

Simone



Sat, 29 May 2004 05:33:09 GMT
 Print without Scientific Notation

simone,


-oj


Quote:
> How do I display 1112620 instead of 1.11262e+006?




> Result:
> 1.11262e+006

> Thanks,

> Simone



Sat, 29 May 2004 05:41:09 GMT
 Print without Scientific Notation


Zach


Quote:
> How do I display 1112620 instead of 1.11262e+006?




> Result:
> 1.11262e+006

> Thanks,

> Simone



Sat, 29 May 2004 05:44:34 GMT
 Print without Scientific Notation
e c h o ! :)

-oj


Quote:


> Zach



> > How do I display 1112620 instead of 1.11262e+006?




> > Result:
> > 1.11262e+006

> > Thanks,

> > Simone



Sat, 29 May 2004 05:48:43 GMT
 Print without Scientific Notation
oj,

How do we know that you just didn't reset your system clock so it only
appears as you posted before Zach   :-)

BPM


Quote:
> e c h o ! :)

> -oj




> > Zach



> > > How do I display 1112620 instead of 1.11262e+006?




> > > Result:
> > > 1.11262e+006

> > > Thanks,

> > > Simone



Sat, 29 May 2004 11:14:15 GMT
 Print without Scientific Notation
hehehhehe... i forgot about that little trick...thanks for the reminder.
will have to use it on you. :)

-oj


Quote:
> oj,

> How do we know that you just didn't reset your system clock so it only
> appears as you posted before Zach   :-)

> BPM



> > e c h o ! :)

> > -oj




> > > Zach



> > > > How do I display 1112620 instead of 1.11262e+006?




> > > > Result:
> > > > 1.11262e+006

> > > > Thanks,

> > > > Simone



Sat, 29 May 2004 11:37:24 GMT
 Print without Scientific Notation
oj,

No problem. I'm like Joe ... I'm less interested in being the first to post,
and more interested in providing the best information    :-)

BPM


Quote:
> hehehhehe... i forgot about that little trick...thanks for the reminder.
> will have to use it on you. :)

> -oj



> > oj,

> > How do we know that you just didn't reset your system clock so it only
> > appears as you posted before Zach   :-)

> > BPM



> > > e c h o ! :)

> > > -oj




> > > > Zach



> > > > > How do I display 1112620 instead of 1.11262e+006?




> > > > > Result:
> > > > > 1.11262e+006

> > > > > Thanks,

> > > > > Simone



Sat, 29 May 2004 11:51:28 GMT
 Print without Scientific Notation
best info?! hmm... will have to consult my magic ball... :)

-oj


Quote:
> oj,

> No problem. I'm like Joe ... I'm less interested in being the first to
post,
> and more interested in providing the best information    :-)

> BPM



> > hehehhehe... i forgot about that little trick...thanks for the reminder.
> > will have to use it on you. :)

> > -oj



> > > oj,

> > > How do we know that you just didn't reset your system clock so it only
> > > appears as you posted before Zach   :-)

> > > BPM



> > > > e c h o ! :)

> > > > -oj




> > > > > Zach



> > > > > > How do I display 1112620 instead of 1.11262e+006?




> > > > > > Result:
> > > > > > 1.11262e+006

> > > > > > Thanks,

> > > > > > Simone



Sat, 29 May 2004 11:57:56 GMT
 Print without Scientific Notation
oj,

Well, I got TWO magic balls ... and I ain't going to do further elaboration
on that    :-)

BPM


Quote:
> best info?! hmm... will have to consult my magic ball... :)

> -oj



> > oj,

> > No problem. I'm like Joe ... I'm less interested in being the first to
> post,
> > and more interested in providing the best information    :-)

> > BPM



> > > hehehhehe... i forgot about that little trick...thanks for the
reminder.
> > > will have to use it on you. :)

> > > -oj



> > > > oj,

> > > > How do we know that you just didn't reset your system clock so it
only
> > > > appears as you posted before Zach   :-)

> > > > BPM



> > > > > e c h o ! :)

> > > > > -oj




> > > > > > Zach



> > > > > > > How do I display 1112620 instead of 1.11262e+006?




> > > > > > > Result:
> > > > > > > 1.11262e+006

> > > > > > > Thanks,

> > > > > > > Simone



Sat, 29 May 2004 12:36:51 GMT
 Print without Scientific Notation
ROTFLMAO

Reminds me of a women athlete that used to rely heavily on steroids. One day
she comes to the doctor and tells him that she has hair growing in peculiar
places. The doctor inquires where? She answers, SELECT
CAST(0x496E206D792062616C6C73 AS VARCHAR). ;-)

--
BG

SQL Server MVP
Hi-Tech College, Israel
http://sql.hi-tech.co.il


Quote:
> oj,

> Well, I got TWO magic balls ... and I ain't going to do further
elaboration
> on that    :-)

> BPM



> > best info?! hmm... will have to consult my magic ball... :)

> > -oj



> > > oj,

> > > No problem. I'm like Joe ... I'm less interested in being the first to
> > post,
> > > and more interested in providing the best information    :-)

> > > BPM



> > > > hehehhehe... i forgot about that little trick...thanks for the
> reminder.
> > > > will have to use it on you. :)

> > > > -oj



> > > > > oj,

> > > > > How do we know that you just didn't reset your system clock so it
> only
> > > > > appears as you posted before Zach   :-)

> > > > > BPM



> > > > > > e c h o ! :)

> > > > > > -oj




> > > > > > > Zach



> > > > > > > > How do I display 1112620 instead of 1.11262e+006?




> > > > > > > > Result:
> > > > > > > > 1.11262e+006

> > > > > > > > Thanks,

> > > > > > > > Simone



Sat, 29 May 2004 18:05:14 GMT
 Print without Scientific Notation
hehehehe!

-oj


Quote:
> ROTFLMAO

> Reminds me of a women athlete that used to rely heavily on steroids. One
day
> she comes to the doctor and tells him that she has hair growing in
peculiar
> places. The doctor inquires where? She answers, SELECT
> CAST(0x496E206D792062616C6C73 AS VARCHAR). ;-)

> --
> BG

> SQL Server MVP
> Hi-Tech College, Israel
> http://sql.hi-tech.co.il



> > oj,

> > Well, I got TWO magic balls ... and I ain't going to do further
> elaboration
> > on that    :-)

> > BPM



> > > best info?! hmm... will have to consult my magic ball... :)

> > > -oj



> > > > oj,

> > > > No problem. I'm like Joe ... I'm less interested in being the first
to
> > > post,
> > > > and more interested in providing the best information    :-)

> > > > BPM



> > > > > hehehhehe... i forgot about that little trick...thanks for the
> > reminder.
> > > > > will have to use it on you. :)

> > > > > -oj



> > > > > > oj,

> > > > > > How do we know that you just didn't reset your system clock so
it
> > only
> > > > > > appears as you posted before Zach   :-)

> > > > > > BPM



> > > > > > > e c h o ! :)

> > > > > > > -oj




> > > > > > > > Zach



> > > > > > > > > How do I display 1112620 instead of 1.11262e+006?




> > > > > > > > > Result:
> > > > > > > > > 1.11262e+006

> > > > > > > > > Thanks,

> > > > > > > > > Simone



Sun, 30 May 2004 01:36:18 GMT
 Print without Scientific Notation
Itzik,

:-)

BPM


Quote:
> ROTFLMAO

> Reminds me of a women athlete that used to rely heavily on steroids. One
day
> she comes to the doctor and tells him that she has hair growing in
peculiar
> places. The doctor inquires where? She answers, SELECT
> CAST(0x496E206D792062616C6C73 AS VARCHAR). ;-)

> --
> BG

> SQL Server MVP
> Hi-Tech College, Israel
> http://sql.hi-tech.co.il



> > oj,

> > Well, I got TWO magic balls ... and I ain't going to do further
> elaboration
> > on that    :-)

> > BPM



> > > best info?! hmm... will have to consult my magic ball... :)

> > > -oj



> > > > oj,

> > > > No problem. I'm like Joe ... I'm less interested in being the first
to
> > > post,
> > > > and more interested in providing the best information    :-)

> > > > BPM



> > > > > hehehhehe... i forgot about that little trick...thanks for the
> > reminder.
> > > > > will have to use it on you. :)

> > > > > -oj



> > > > > > oj,

> > > > > > How do we know that you just didn't reset your system clock so
it
> > only
> > > > > > appears as you posted before Zach   :-)

> > > > > > BPM



> > > > > > > e c h o ! :)

> > > > > > > -oj




> > > > > > > > Zach



> > > > > > > > > How do I display 1112620 instead of 1.11262e+006?




> > > > > > > > > Result:
> > > > > > > > > 1.11262e+006

> > > > > > > > > Thanks,

> > > > > > > > > Simone



Sun, 30 May 2004 05:20:38 GMT
 
 [ 12 post ] 

 Relevant Pages 

1. Doing away with the scientific notation

2. How to avoid scientific notation?

3. Enterprise Manager - Scientific Notation

4. Scientific Notation - Float datatype

5. !---Scientific Notation

6. NVARCHAR field converting integers to scientific notation

7. scientific notation

8. Converting numeric in scientific notation in char field to integer

9. !---Scientific Notation in tables

10. scientific notation (or symbols) into SQL SERVER 7

11. Strings converting to Scientific Notation!!!

12. Scientific Notation


 
Powered by phpBB® Forum Software