The STARTING WITH conditional expression tests for the presence
of a specified string at the beginning of a string expression. A
STARTING WITH conditional expression is true if the second string
expression begins with the characters specified in the first
string expression.
If you precede the STARTING WITH expression by the optional NOT
qualifier, the condition is true if the first value expression
does not begin with the characters specified by the second value
expression.
The STARTING WITH conditional expression is case-sensitive; it
considers uppercase and lowercase forms of the same character to
be different.
Additional Information:
explode
extract