SUBSTR

=SUBSTR =

**SUBSTR**(//char//, //s//[,//l//])
A substring of char, starting at character s, length l

DESCRIPTION:
A subsequence, substring, prefix or suffix of a string is a subset of the symbols in a string, where the order of the elements is preserved. In this context, the terms string and sequence have the same meaning.

Examples :
SELECT SUBSTR('Luisisssmart',1,4) FROM DUAL
 * SUBSTR (Luisissmart',' 1,4) ||
 * Luis ||

Select SUBSTR('SEIDAfailedthechemistrytest',1,5) FROM employees
 * SUBSTR('SEIDAFAILEDTHECHEMISTRYTEST',1,5) ||
 * SEIDA ||

Select SUBSTR('REZLINDISALBANIAN',1,7) FROM DUAL
 * SUBSTR('REZLINDISALBANIAN',1,7) ||
 * Rezlind ||