All Forums Database
Prabhu_Teradata 17 posts Joined 06/12
10 Sep 2012
Replace Function


          Need Help on Replace Function



There is column with Value:  Text1 , Text2 , Text3;

Need to Replace it as Text1 Text2 Text3


Other Information:

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.





Thanks, Prabhu
Qaisar Kiani 337 posts Joined 11/05
10 Sep 2012

If you dont have the UDFs installed then try the recursive SQL. It should solve your problem.

You must sign in to leave a comment.