Re: HELP!!!! Strange select statement output

I had this once upon a time with EAN codes.

Try

Select to_char(f_docnumber) from doctaba;

There could be a variable in SQL*Plus to display long numbers as numbers and not convert to scientific format which we are not aware of.

Mark

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 Thu Mar 25 1999 - 00:00:00 CET