SUBSTRING Function

Parameters (String, Integer, Integer);

Returns: String;

Function to obtain a part of a given source string.

The first parameter is the source string.

The second parameter is the index of the start character (zero based, inclusive).

The third parameter is the index of the end character (zero based,exclusive).

If the third parameter is 0, the start character to the end of the string will be included.

Example:  SUBSTRING('Hamburger',4,8) = ‘urge'

Example:  SUBSTRING('Hamburger',3,0) = 'burger'