• ⌂ Text
• Functions
  • CHAR_LENGTH()
  • CONCAT()
  • ENUM()
  • FIND_ALL_IN_SET()
  • FIND_ANY_IN_SET()
  • FIND_IN_SET()
  • INSTR()
  • LEFT()
  • LENGTH()
  • LOCATE()
  • LOWER()
  • LPAD()
  • LTRIM()
  • MATCHES()
  • ORD()
  • REVERSE()
  • RIGHT()
  • RPAD()
  • RTRIM()
  • SUBSTR()
  • SUBSTRING()
  • TRIM()
  • UPPER()

SUBSTRING()

Return a portion of a string based on a starting position and optional length.  A starting position of 1 represents the first character.

Prototype

string SUBSTRING(string str, int position[, int length])

Parameters

• str - The string or expression to evaluate to a string to extract the sub-string from.
• position - Position from start of str to begin the substring, where 1 is the first character.  If a negative value is provided, the beginning of the substring is that number of characters from the end of the string, rather than the beginning.  If zero is specified, an empty string is returned.
• length - Optional number of characters from the position to include in the substring.  If no value is provided, all characters through the end of str will be included.

Return

Return the portion of a string starting at position up to the end or optional length characters.

Example

SELECT OID, SUBSTRING(Username, 1, 8) AS FirstEight FROM User

• < SUBSTR()
• TRIM() >