Replaces all occurrences of one string value with a new string value within another string value.

Syntax

---

REPLACE(<StringExpression> WITH <StringExpression>
        IN <StringExpression>)
REPLACE(<StringExpression>, <StringExpression>,
        <StringExpression>)

<StringExpression> = 

Type of:

CHARACTER|CHAR
CHARACTER VARYING|VARCHAR
GUID
CHARACTER LARGE OBJECT|CLOB

Returns

---

Same as last input

Usage

---

The REPLACE function replaces all occurrences of a given string with a new string within another string. If the search string is not present, then the result will be the input string.

Examples

---

UPDATE Customers
SET Notes = REPLACE( 'Complaint' WITH 'Suggestion' IN Notes)

SQL 2003 Standard Deviations

---

This function deviates from the SQL 2003 standard in the following ways: