Re: Re: selecting with thousands separator
Hope ? Nah, that doesn't work.
create table floyd
(
col1 integer
) extent size 32 next size 32 lock mode page;
insert into floyd (col1) values (25000)
select replace(col1::decimal, '.', ',') from floyd
(expression)
25000,0000000000000000
----- Original Message -----
Subject: Re: Re: selecting with thousands separator
Date: Thu, February 14, 2008 6:37
From: "Roland Wintgen" <rw@evg.de>
>>> Jonathan Leffler<jleffler@earthlink.net> schrieb am 14.02.2008 um
> 04:51:
> > Jack Parker wrote:
> >> Floyd Wellershaus asked:
> >>> Is there a way to select an integer or string value out of a table and
> >>> have it display in this format xx,xxx ?
> >>
> >> Isn't there a DBLDFORMAT variable (or something like that) that
> >> dictates how numbers are formatted?
> >
> > I suspect you're thinking of DBFORMAT, but that is only supported by
> > I4GL and not by IDS.
>
> assuming you have a decimal or float value and want ro
> replace the thousand separator from "." to "," you could
> you do a select replace(value, ".", ",")
>
>
> --
>
> Roland Wintgen (Systemadministrator)
>
> rw@evg.de
> Tel. +49 2166 5508-23
> Fax +49 2166 5508-20
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
>