number formatting

[james]

Hi

Im having a problem getting a number to display correctly. The number is
the result of a calculation and I am then using formatnumber to remove any
decimals.

The number displays as '1,345' is there any way to get rid of the comma

Thanks

J

 

[Aaron Bertrand [SQL Server MVP]]

Did you read the documentation on formatnumber? One of the arguments is
"groupDigits" which means use comma separators between thousands...

 

[james]

Thanks

Should have checked thought you could only set the no of decimal plaves

J