REPLACE
Syntax
REPLACE (string_expression, search_string, replacement_string)
Description
In string_expression, replaces all occurrences of search_string with the replacement_string.
Arguments
| string_expression | The string to modify. |
| search_string | The characters to modify within the string. |
| replacement_string | The new characters to replace the search_string. |
Returns
The modified string_expression.
Remarks
If replacement_string is empty, the characters in search_string are deleted.
If no instances of search_string are found, the original string_expression value is returned.
Example
REPLACE ("97201", "01", "39")
REPLACE (MyEntity.Zip, "01", "39")
Both Return: 97239