SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 04:33 PM
| ||||
| ||||
 Re: selecting with thousands separator 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 ? Easiest way's to write a small UDR to format the value in 'C' and return the string. You could then create a formatted number UDT and use the function as a cast converter or just call it in the projection list of a query. Shouldn't be more than 15 or 20 lines of 'C' at most, compile it into a shared library, and a one-line SQL to register the function and give it an SQL name. Art S. Kagel Oninit > > Thanks, > Floyd > > ------------------------------------------------------------------------ > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > ================================================== ========================================= Please access the attached hyperlink for an important electronic communications disclaimer: http://www.oninit.com/home/disclaimer.php ================================================== =========================================      |
Linear Mode
