SEO

#1 (**permalink**) 04-20-2008, 04:33 PM

Is there a way to select an integer or string value out of a table and have it display in this formatÂ* xx,xxxÂ*Â*Â* ?

Thanks,
Floyd

#2 (**permalink**) 04-20-2008, 04:33 PM

On Feb 13, 4:13*pm, "Floyd Wellershaus" <fl...@fwellers.com> wrote:
> Is there a way to select an integer or string value out of a table and have it display in this format* xx,xxx*** ?
>
> Thanks,
> Floyd

The best way of doing this would depend what you are selecting the
data into

Windows, GLS and IDS settings will all have an impact on ho wthey
data is displayed

The DBMONEY environment variable specifies the display format of
values in columns of smallfloat, FLOAT, DECIMAL, or MONEY data types,
and of complex data types derived from any of these data types.

.-'$'------. .-.-.
>>-setenv--DBMONEY--+-front----+--+-,-+--+--------+------------><
'-'front '-' +-back---+
'-'back'-'

$
is a currency symbol that precedes MONEY values in the default locale
if no other front symbol is specified, or if DBMONEY is not set.
, or .
is a comma or period (the default) that separates the integral part
from the fractional part of the FLOAT, DECIMAL, or MONEY value.

Whichever symbol you do not specify becomes the thousands separator.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

selecting with thousands separator