MID

Purpose

This function returns a substring of length length from position position out of the string string.

Usage notes

• If length is not specified, all of the characters to the end of the string are used.

• If position is negative, counting begins at the end of the string.

• If position is 0 or 1, the result begins from the first character of the string.

• If position is before the start or after the end of the string, the result is NULL.

• For additional information, refer to the functions RIGHT, LEFT, and REGEXP_SUBSTR.

• MID is an alias for SUBSTR[ING].

Example

SELECT MID('abcdef',2,3) S1,
       MID('abcdef',-3) S2,
       MID('abcdef',7) S3,
       MID('abcdef',-7) S4
       ;

Result: