Replace

Returns a string in which a specified substring has been replaced with another substring a specified number of times.

Syntax

string Replace (
    string value,
    string oldValue,
    string newValue
)

Parameters

value

A string expression representing the string to be searched for.

oldValue

A string expression representing the substring to be replaced.

newValue

A string expression representing the substring to replace all occurrences of oldValue.

Return Value

A string equivalent to value but with all instances of oldValue replaced with newValue. If any of the specified parameters is null, null is returned.

See Also

Text Functions
Left Function
RTrim Function