Re: SQL SELECT displaying commas in numerics

["Charles Wilt" <charles.wilt@xxxxxxxxx>]

If you want a pretty report, create a query manager query (STRQM).

Charles

On Wed, Dec 17, 2008 at 2:15 PM, Charles Wilt <charles.wilt@xxxxxxxxx>wrote:

> Nope.
>
> IMHO, STRSQL is a "quick & dirty" interface.  If you're trying to do
> something where the existance of the thousand seperate is a real problem,
> you're probably using the wrong interface.
>
> Charles
>
>
> On Wed, Dec 17, 2008 at 1:55 PM, Dan <dan27649@xxxxxxxxx> wrote:
>
> > In interactive SQL, numerics by default display with commas for the
> > thousands separator.  Is there a way to lose the commas?
> >
> > Note that I'm using SELECT * FROM CUSTMAST, and I really don't want to
> > list
> > every field in the file to have to use DIGITS(CUSTNO).
> >
> > I looked at changing the session attriubtes (F13), where you get choices
> > for
> > the decimal point, and for date & time format / separators, but nothing
> > for
> > thousands' separators.
> >
> > TIA,
> > Dan
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.