Re: HELP!!! sql select command output

Article View: alt.comp.databases

Article #84

Back to alt.comp.databases Previous Next

#84

From: rpdata
Date: Thu, 25 Mar 1999 00:00

47 lines
2217 bytes

You can try  

column <column_name> format 999,999,999,999,999,999

On Wed, 24 Mar 1999 15:19:02 -0800, "Chris Reddy" <iiidana@gte.net>
wrote:

>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: <36f98aa3.86601136@news.cyberus.ca>

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

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 122e4d,cfaa4b53dc1c492c
X-Google-Attributes: gid122e4d,public
X-Google-Thread: fa4f9,cfaa4b53dc1c492c
X-Google-Attributes: gidfa4f9,public
X-Google-Thread: fc5c9,cfaa4b53dc1c492c
X-Google-Attributes: gidfc5c9,public
X-Google-Thread: 11355a,cfaa4b53dc1c492c
X-Google-Attributes: gid11355a,public
X-Google-Thread: 104de1,cfaa4b53dc1c492c
X-Google-Attributes: gid104de1,public
X-Google-Thread: f99a8,cfaa4b53dc1c492c
X-Google-Attributes: gidf99a8,public
X-Google-Thread: 10a90d,cfaa4b53dc1c492c
X-Google-Attributes: gid10a90d,public
X-Google-Thread: fdf39,cfaa4b53dc1c492c
X-Google-Attributes: gidfdf39,public
From: rpdata@cyberus.ca
Subject: Re: HELP!!! sql select command output
Date: 1999/03/25
Message-ID: <36f98aa3.86601136@news.cyberus.ca>
X-Deja-AN: 458739185
X-Cyberus: NNTP Proxy version 1.1
References: <7dbqr5$2nm$1@news-1.news.gte.net>
X-Posting-IP: ip206.ts15.mn.dialup.ottawa.cyberus.ca (209.195.86.206)
X-Complaints-To: newsabuse@remarQ.com
X-Trace: 922323417.039.43 1WFMZI46C5F10D1C3C usenet1.supernews.com
Organization: Posted via RemarQ Communities, Inc.
NNTP-Posting-Date: Thu, 25 Mar 1999 00:56:57 GMT
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

Reply to Parent Message