Sql Query - Remove Commas Within Select Statement
I Am Running a Sql Query on Some Customer Data. Within My Select Statement I Ideally Need to Remove All Commas. (I Am Not Looking to Update My Source Tables.)...
I am running a SQL query on some customer data. Within my Select statement I ideally need to remove all commas.(I am not looking to update my source tables.)
Not certain how to do this on all fields and all columns, so any help or insight would be much appreciated.
If you need any additional information, please let me know.
Thank you,
Allison
1 Answer
I assume that you need to remove the commas in any of your data (in columns) and replacing the comma by a space
Select Replace(ColA,',',' ') as ColA, Replace(ColB,',',' ') as ColB ...
From
Sophia analyzes international trade, startup ecosystems, retail transformation, and supply chain logistics for modern digital publications.
