HELP!!!! Strange select statement output
From: Chris Reddy <iiidana_at_gte.net>
Date: 1999/03/24
Message-ID: <7dbprb$lbt$1_at_news-1.news.gte.net>#1/1
Date: 1999/03/24
Message-ID: <7dbprb$lbt$1_at_news-1.news.gte.net>#1/1
Hi All,
I'm performing a select statement on a database and the field that I am
querying on contains a numeric value in the billions, and my output is
displayed in scientific format.
select f_docnumber from doctaba
The return output is:
I want to view the number which would be
3000002254
3.000E+09
3.000E+09
3.000E+09
3000002255
3000002256
What is the select condition I need to use in order to view the number how I want.
I am stumped.
Any help would be greatly appreciated.
You can e-mail me at iiidana_at_ix.netcom.com or post to the group.
Thanks in advance,
Chris Reddy
Received on Wed Mar 24 1999 - 00:00:00 CET