Re: HELP!!!! Strange select statement output

From: CruxRealm <cruxrealm_at_netscape.com>
Date: 1999/03/24
Message-ID: <WgeK2.24999$FZ5.7638_at_news.rdc1.sfba.home.com>#1/1


Try setting your column format.

Chris Reddy wrote in message <7dbprb$lbt$1_at_news-1.news.gte.net>...
>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:
>
>3.000E+09
>3.000E+09
>3.000E+09
>
>I want to view the number which would be
>3000002254
>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

Original text of this message