Description:
SUBSTR returns a substring of the text passed in the first parameter. The
substring starts with the character offset specified by the second parameter, and
has a length up to the length specified by the third parameter or the actual
length of the text argument, whichever is shorter.
Syntax:
string := SUBSTR ( { buffer | range | string }, integer_offset )
string := SUBSTR ( { buffer | range | string }, integer_offset, integer_length
)
Example:
abc := SUBSTR ("123abc456", 4, 3);
Errors:
TPU$_STRTOOLARGE Strings can be up to 65,535 characters.
TPU$_TRUNCATE String length too long; had to be shortened.
Related Builtins:
SUBSTR