OREPLACE

Teradata Vantageā„¢ SQL Functions, Expressions, and Predicates

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

Purpose

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.

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.
search_string
A string of characters that the function searches for in source_string.
If search_string is NULL, NULL is returned.
replace_string
A string of characters that replaces the characters specified by search_string.
If replace_string is NULL or is an empty string, or is omitted, all occurrences of search_string are removed from the source_string.