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?


Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!