Prev Up Next
strcontains Home ends_with

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

Example24.416.Simple example 

SQL> select starts_with('AbracadabrA','Abr');
starts_with
INTEGER
_______________________________________________________________________________

1

1 Rows. -- 0 msec.

Prev Up Next
strcontains Home ends_with