16.20 - OTRANSLATE - Advanced SQL Engine - Teradata Database

Purpose

Returns source_string with every occurrence of each character in from_string replaced with the corresponding character in to_string.

Syntax

TD_SYSFNLIB.

Name of the database where the function is located.

source_string

A character string or string expression.

If source_string is NULL, NULL is returned.

from_string

A string of characters that will be replaced in source_string.

If from_string is NULL, the function returns source_string.

to_string

A string of characters that replaces the characters specified by from_string.

If to_string is NULL or empty, the function removes the characters specified in from_string.