SUBSTRING

Returns part of a designated string.

Return Value

String

Syntax

SUBSTRING( string, start [, length] )

where:

  • string is an expression containing the string to be processed.
  • start is a number indicating the starting position from which the substring is to be returned. If start indicates a position beyond the length of string, the system returns an empty string.
  • length (optional) is a number indicating how many characters are to be returned. If length indicates more characters than are remaining in the string from the start location to the end of the string, or if this argument is not used, the system returns the entire remainder of the string from the start location.