Name
starts_with — Checks whether string X begins with Y
Synopsis
starts_with
(
|
in str string , |
in
sub
string
) ; |
Description
starts_with
checks whether string X begins with Y, ignoring occurencies of Y in other places. Returns 1 or 0.
Parameters
str
String to search from.
sub
Substring to search for.
Return Types
1 if found, 0 if not found.
Examples
Example 24.416. Simple example
SQL> select starts_with('AbracadabrA','Abr'); starts_with INTEGER _______________________________________________________________________________ 1 1 Rows. -- 0 msec.