OREPLACE Function | VantageCloud Lake - OREPLACE - Teradata VantageCloud Lake

Replaces every occurrence of search_string in the source_string with the replace_string. Use this function either to replace or remove portions of a string.

OREPLACE is an embedded services system function.

To activate and invoke embedded services functions, see Embedded Services System Functions.

• OREPLACE Function Syntax
• OREPLACE Argument Types and Rules
• OREPLACE Result Type
• OREPLACE Usage Notes
• OREPLACE Function Examples

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.