Remove dots and commas from column values

in sql server you can use REPLACE for remove data and STUFF to add data

as follows

replace('Your String','charater you want to replace','with what')


stuff('Your String',position,count,'data') 

In SQL SERVER you could use REPLACE.

SELECT REPLACE(REPLACE('abc,123.456', ',', ''), '.', '')