Hello,   I have a query using OREPLACE that runs in one environment, but fails in another with:   Executed as Single statement. Failed [7509 : HY000] Result Exceeded maximum length for UDF/XSP/UDM pm_edw_etl_load.oreplace2. Elapsed time = 00:00:00.437 STATEMENT 1: SEL failed.  

Below is the statement that is a part of a stored procedure.  SET NOTNULLKEYLIST=' COALESCE('||OREPLACE(pkcollist,',',',''-1''),COALESCE(')||',''-1'') ';  

Hello - I have a messy dataset that has values like this: 1=Very Dissatisfied, 2, 3...9, Very Satisfied=10. I have used a Case statement in the past to remove the words and '=' sign, but was thinking I could use the OReplace that was part of Teradata 14.

  Hi All,   As a part of validating a requirement I need to remove special characters from a string .so could you please suggest any function to remove special characters from a string or to replace the special characters in a string with blanks?  

Hi, I am trying to replace a special character with CRLF in Teradata table using OReplace func but somehow its not working and I am getting "Select Failed.9134" error. The special Character may appear anywhere in the text.And the ColumnDatatype is generally text field  for eg: CLOB, VARCHAR(32000).  

Hi All I'm trying to implement Oracle REPLACE() function in teradata using SQL statements only. I searched the forum , but found Oreplace() UDF as the only solution.  Can someone help me in implementing this is pure teradata SQL  ??  Thanks Praneeth