To replace dot with comma on SELECT, you can use REPLACE().
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.
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?
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With