Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Remove dots and commas from column values

Tags:

People also ask

How do I remove a dot in SQL query?

To replace dot with comma on SELECT, you can use REPLACE().

How do I remove all commas in a column in python?

How do I remove a comma from a column in Python? Using replace() function, we swap the commas in the python string with null elements.

How do I get the values in a comma separated column?

In Excel, CONCATENATE function can convert the column list to a list in a cell separated by commas.


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?