Replace Function

Database
Enthusiast

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.

Tags (1)
1 REPLY
Enthusiast

Re: Replace Function

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