sql server - Remove dots and commas from column values

Question

I am using SQL Server 2008

I migrated some data from MySql; the migration of data was successful but some values contain data with dots and commas.

What is the best way to remove these characters from my data?

Answer 1

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')