Prev Up Next
starts_with Home tcpip_gethostbyname

Name

ends_with — Checks whether string X ends with Y

Synopsis

ends_with ( in str string ,
in sub string );

Description

ends_with checks whether string X ends 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.417.Simple example 

SQL> select ends_with('AbracadabrA','rA');
ends_with
INTEGER
_______________________________________________________________________________

1

1 Rows. -- 0 msec.

Prev Up Next
starts_with Home tcpip_gethostbyname