CELKO (12/1/2012)
to add comma as the thousand separator
NO! Display formatting is done in the presentation layers of any tiered architecture. The proprietary MONEY data type is left-over from the 1970's Sybase dialect. It formats numeric values to look like they had been written with a COBOL PICTURE clause.
01 FOOBAR PICTURE $999,999,999,999V9999
We do not do this in SQL any more.
Joe, you're a dinosaur like me. Most people on this forum probably don't even know what COBOL is.