Returns a portion of character data. The portion of data returned begins at the specified position and is the specified substring length characters long.
SUBSTR calculates lengths using characters as defined by the input character set.
The following restrictions apply when you use the
SUBSTR function in the
The function supports only positive integers. It does not support negative values or floating-point numbers.
SELECT command does not support the following functions:
This example shows each
problem_key starting with the fifth character in the key.
select substr(problem_key, 5) from problem;