MID

Purpose

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

Syntax

mid::=

Usage Notes

  • If length is not specified, all of the characters to the end of the string are used.
  • The first character of a string has position 1. If position is negative, counting begins at the end of the string.
  • For additional information, refer to functions RIGHT and LEFT.
  • MID is an alias for SUBSTR[ING].

Example

SELECT MID('abcdef',2,3) MID;