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].