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