INSERT

INSERT(originalString, startInt, lengthInt, addString)
  • originalString - an original string.
  • startInt - start position.
  • lengthInt - the length.
  • addString - an additional string.

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.

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

Updated about 5 years ago