Is there any way to simulate the oracle's replace function in TD (other than using the UDF oreplace)?
I am facing problem using this: app_user.oreplace(content_name,'|',' ')
Whenever i try using this it throws the following error: " A column or character expression is larger than the max size."
content_name field has a length of 500.
The reason i want to use replace function is that we have to generate "|" delimited files and it can be possible that content_name itself contain "|" so to address that i wanted to replace a '|' with ''.