Sample Table name :Employee

EmployeeId	Name	Location
123	Keven	Newyork
456	david	Chicago

OREPLACE Function in Teradata

The OREPLACE function is used to replace the every occurrence of search string in the source_string with the replace_string.

Syntax

SELECT OREPLACE(‘original_string’,’string_to_replace’,’new_string’)

Example

SELECT OREPLACE(Name,’Keven’,’Smith’) as Name from EMPLOYEE;

Name

Smith

david

OTRANSLATE Function in Teradata

The OTRANSLATE function is used to replace the every search characters to the corresponding replace characters in the original string.

Syntax 

SELECT OTRANSLATE(‘original_string’,’search_characters’,’replace_characters’)

Example 

SELECT OTRANSLATE(Name,’di’,’ne’) as Name from employee;

Name

Keven

naven

Recommended Articles

• Replace the string using REGEXP_REPLACE function in Teradata
• Regexp_substr function in Teradata with examples
• Substring function in Teradata with examples
• How to extract the position of the substring in Teradata