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:
TRUELast updated