you can make use of a combination of postition, substring, character_length functions and the concatenation operator (||) to accomplish this. The syntax and details are available in the functions and operators manual.
If you are looking to replace a single occurence of a string in a field, Index (or ANSI Position) statement will do it fine. For multiple occurences, you can get the oreplace UDF from Teradata.com. Format is: