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