Windows XP Tablet Ed.Windows 2008 R2EmbeddedWindows 2008Windows VistaWindows 2003Windows 2000Windows XPSQLWindows
Display number or amount with commas but no decimal places or extension displayed





0/5 (0 vote)
Display number or amount with commas but no decimal places or extension displayed
Introduction
This post discusses how to display number or amount with commas, but no decimal places or extension displayed.
Here's the scenario:
I searched for awhile on how could I eliminate the decimal places on a particular field, but not remove the commas.
Like this: 234345455.89
Desired Output: 234,345,456
PARSENAME(CONVERT(varchar, CONVERT(money,txtSparkVolume), 1), 2) as txtSparkVolume,
Using the Code
Here is the solution I made:DECLARE txtGasVolume as float
SET GasVolume = 234345455.89
PARSENAME(CONVERT(varchar, CONVERT(money,GasVolume), 1), 2) as cGasVolume
I hope this helps. Thank you and God bless.