Re: selecting with thousands separator

Posted in 2008

Marco Greco — Wed, 13 Feb 2008 16:38:11 +0000 — source: Usenet: comp.databases.informix

Floyd Wellershaus 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 If you don't need to do that inside the engine, then the FORMAT clause offered by SQSL (see sig) is your friend -- Ciao, Marco ______________________________________________________________________________ Marco Greco /UK /IBM Standard disclaimers apply! Structured Query Scripting Language http://www.4glworks.com/sqsl.htm 4glworks http://www.4glworks.com Informix on Linux http://www.4glworks.com/ifmxlinux.htm