RE: anyone have an SQL FUNCTION like this they can share?

["Neill Harper" <neill.harper@xxxxxxxx>]

I don't have my own, so sorry if this answer isn't quite what you are
looking for but....

Before you roll your own logic you might want to check of the number
formatting that java offers out of the box. 

And plug that into a Java UDF. 

Cheers 

neill

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Michael Rosinger
Sent: 15 June 2009 18:02
To: midrange-l@xxxxxxxxxxxx
Subject: anyone have an SQL FUNCTION like this they can share?

List,

Per a customer request, I need to be able to format a DEC() number with 
commas (hundreds, thousands, millions, etc.) and a decimal point with 
leading zeroes suppressed. I don't believe there is a scalar function that 
can provide the commas. Before I write the function, I was wondering if 
anyone had a similar function they'd be willing to share. TIA