www.mimer.com/developer

The REPLACE Function

---

Syntax for the REPLACE function:

source-string, string-1 and string-2 are character or binary string expressions.

source-string, string-1 and string-2 must be of equal type, i.e. either all are character or all are binary.

Rules:

• All occurrences of string-1 found in source-string are replaced with string-2, the resulting character or binary string is returned.
• If the value of any of the operands is NULL, then the result of the function is NULL.

Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se