Convert field value from 1,000 to numeric

Question

I have a field called "sales" and the source data is piping in a value with a comma (ex: 1,000) instead of 1000 (without commas).

How can I convert this value to a numeric (without commas)?

Thanks in advance!

user_1144035 · Answer

You could remove the comma:

select replace(sales, ',', '')::numeric

user_8651601 · Answer

This should work:

select replace(sales, ',', '')::numeric from tablename;

replace(sales, ',', '') to remove commas (',') and ::numeric to convert value to numeric.