Re: commas in money field

> > > > > >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. _____________________________________________________________________________