REPLACE

Syntax

REPLACE(<string>; <number for start position>; <number of characters to replace>; <string replacement>)

Description

Replaces characters within a text string with a different text string.
Values less than zero for position or length cause an exception for actual data entry.

Examples