Removing Commas in Number Formatting?

[Phoenix22]

Hi,

Is there a way I can remove the "," in a column of numbers so that 1,234 would appear in the table as 1234?

Thank you in advance.

 

[bdreed35]

It is probably not stored as a number if has the comma in it.

This will remove it for you:

select replace(your_field,',','')

If you want to convert it to a number, try this:

select convert(int, replace(your_field,',',''))

~Brian

 

[JayKusch]

SELECT REPLACE(TheNumber,',','')
FROM MyTable

Thanks

J. Kusch