I have a company name that can contain comma's in one or more positions. I need to replace these comma's with a space.
Dom,s Travel and Dom,s Express
Need it to read
Dom s Travel and Dom s Express
select REPLACE('HERE,COMES,SOLUTION,FOR,YOU,', ',', ' ') from dual
> I need to replace these comma's with a space.
The solution is perfect.
Thanks for responding so quickly.