starts_with
Checks whether string X begins with Y
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
Simple example
SQL> select starts_with('AbracadabrA','Abr');
starts_with
INTEGER
_______________________________________________________________________________
1
1 Rows. -- 0 msec.