REPLACE( ) Overwrite or replace substring

The REPLACE( ) function overwrites or replaces a substring within a string with another string. This can make the original string longer.

Result type: STRING

REPLACE( )

STRING = string_expression₁

,START = 1 / integer

,REPLACE = string_expression₂

,SUPPRESSED-LENGTH = *REPLACE-LENGTH / integer