Remove Dots and Commas from Column Values
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...
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?
2 Answers
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', ',', ''), '.', '')
Sophia analyzes international trade, startup ecosystems, retail transformation, and supply chain logistics for modern digital publications.
