HELP!!! sql select command output

Article View: alt.comp.databases

Article #83

Back to alt.comp.databases Previous Next

#83

From: Chris Reddy
Date: Wed, 24 Mar 1999 00:00

31 lines
1859 bytes

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@ix.netcom.com or post to the group.

Thanks in advance,

Chris Reddy

Technical Details

Message-ID: <7dbqr5$2nm$1@news-1.news.gte.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 122e4d,cfaa4b53dc1c492c,start
X-Google-Attributes: gid122e4d,public
X-Google-Thread: fa4f9,cfaa4b53dc1c492c,start
X-Google-Attributes: gidfa4f9,public
X-Google-Thread: 104de1,cfaa4b53dc1c492c,start
X-Google-Attributes: gid104de1,public
X-Google-Thread: f99a8,cfaa4b53dc1c492c,start
X-Google-Attributes: gidf99a8,public
X-Google-Thread: 10a90d,cfaa4b53dc1c492c,start
X-Google-Attributes: gid10a90d,public
X-Google-Thread: fc5c9,cfaa4b53dc1c492c,start
X-Google-Attributes: gidfc5c9,public
X-Google-Thread: fdf39,cfaa4b53dc1c492c,start
X-Google-Attributes: gidfdf39,public
X-Google-Thread: 11355a,cfaa4b53dc1c492c,start
X-Google-Attributes: gid11355a,public
From: "Chris Reddy" <iiidana@gte.net>
Subject: HELP!!! sql select command output
Date: 1999/03/24
Message-ID: <7dbqr5$2nm$1@news-1.news.gte.net>
X-Deja-AN: 458701459
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
Organization: gte.net
X-Auth: DE0D8B1513DBC5924ECD8491
X-MSMail-Priority: Normal
Newsgroups: alt.comp.databases,bit.listserv.sqlinfo,comp.database,comp.databases,comp.databases.ms-sqlserver,comp.databases.oracle.misc,comp.databases.oracle.server,ncr.databases.oracle