SUBSTR

SUBSTR(string,m[,n])

Returns a substring of a string, beginning at position m for n characters.

  • If you specify m=0, the whole string is returned.
  • If you specify a negative number, the function returns the number of characters specified from the end of the string.
  • If you don't specify n, the default is to return all characters starting from m.