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

Hi,

          Need Help on Replace Function

 

Senario:

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
Tags:
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.