INSERT

INSERT(originalString, startInt, lengthInt, addString)

Parameters

• originalString - an original string.
• startInt - start position.
• lengthInt - the length.
• addString - an additional string.

Description

Inserts a additional string into the original string at a specified start position. The length specifies the number of characters that are removed at the start position in the original string. This method returns a string.

Example

SELECT INSERT(NAME, 1, 1, ' ') FROM Players;