Re: Re: selecting with thousands separator

>>> 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