Replace string function in stored procedure?

[CapsuleCorpJX]

Is there a replace string function in Stored Procedure?

Like
newstring = string_replace(oldstring, <old value>, <new value);

Or bascially look for a substring = <old value> in oldstring, and replace it with <new value> and store it in newstring.

 

[EdgarNg]

there are no functions or store procedures that comes with Teradata with replace string, however you can go into Teradata.com, search for UDF, there is one UDF, (user defined function) called replace that you can use.