REGEXP_LIKE_UDF (STRING, STRING, STRING)

Definition

This user-defined function (UDF) is

REGEXP_LIKE_UDF(COL STRING, PATTERN STRING, MATCHPARAM STRING) 

Parameters

COL STRING

The string to be evaluated with the pattern.

PATTERN STRING

The pattern to be checked.

MATCHPARAM STRING

The match parameter that will determine whether the case-sensitive or not.

Returns

Returns

Usage example

Input:

SELECT REGEXP_LIKE_UDF('san Francisco', 'San* [fF].*', 'i');

Output:

TRUE