Re: commas in money field -Reply
If someone wnated to stick solely with sql then presumably the select could use an sp that converts and formats the output? select addcommas(MyMoneyField) from blah etc... -- -- Peter Tashkoff NZ Kiwifruit Project Consultant/DBA Marketing Board. Standard Disclaimers apply This posting may not be used by any commercial organisation to vilify another. >>> Jack Parker <jparker@boi.hp.com> 11/July/1996 07:15am >>> > > > > > >Can anyone tell me how I can get commas inserted into the > >output of the dollar portion of the money datatype? For > >example, if a column is of type money(13,2) and has a > >value of 1234567.89, I like the output of that column from > >a simple select statement to be $1,234,567.89. > > > >I have OnLine Dynamic Server 7.12 UC1 running on Solaris 2.4. > > > >David. > > > >ps. I've tried setting LC_MONETARY; it does not do what I want. > > Money as such has no commas or dollar signs associated with the data until you filter it through a mask like Richard suggested. So - you are forced into using a front end tool of some form - be it 4gl, ace, forms, whatever. cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@nexus.boi.hp.com <--- New address _____________________________________________________________________________ If anything can go wrong, fix it. To hell with Murphy. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________