replace

Replace a string within another string

Syntax

replace(string_expr,string_expr,string_expr)

Arguments

string_expr	The string in which to make the replacement.
string_expr	The substring of strexp1 to be replaced.
string_expr	The replacement string.

Description

This scalar string function replaces all occurrences of strexp2 in strexp1 with strexp3.  If the function does not find any occurrences of strexp2, it returns strexp1.  The three string parameters can be ASCII or Unicode strings.  If one of them is Unicode, the others are implicitly converted into Unicode before replacement and the function returns a Unicode string.