06-25-2008
1,
0
Join Date: Jun 2008
Last Activity: 26 June 2008, 10:40 AM EDT
Posts: 1
Thanks Given: 0
Thanked 0 Times in 0 Posts
Formatting amounts
Hi,
I am exporting data from a table with 4 columns into a file. The 4th column contains amount which is decimal(11,2) with values ranging from 0.00 to 999999999.99. I need to mail this file to the users but before doing that i need to format the amount column as 999,999.00 instead of 999999.00
ex: input file
ab1,1234,gter,100000.00
ab2,1234,gter,500.00
ab3,1234,gter,999999999.99
output file should be
ab1,1234,gter,100,000.00
ab2,1234,gter,500.00
ab3,1234,gter,999,999,999.99
Thanks in advance
Sri