RE: selecting with thousands separator

Isn't there a DBLDFORMAT variable (or something like that) that dictates how numbers are formatted? j. Sane ego te vocavi. Forsitan capedictum tuum desit. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]On Behalf Of Floyd Wellershaus Sent: Wednesday, February 13, 2008 11:14 AM To: informix-list@iiug.org Subject: selecting with thousands separator 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

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. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2007.0914 -- http://dbi.perl.org/ publictimestamp.org/ptb/PTB-2517 ripemd128 2008-02-14 03:00:07 E8275FB48AAA5A7A395429FB0FF9D7BD