Need Help on Replace Function
There is column with Value: Text1 , Text2 , Text3;
Need to Replace it as Text1 Text2 Text3
1. OREPLACE function is not installed, Please help me with other possibilities
2. Number of occurance of comma(,) is varying, some time it will occur one time, some time it will occur 5 times.
If you dont have the UDFs installed then try the recursive SQL. It should solve your problem.