REGEXP_LIKE Predicate

Description

The REGEXP_LIKE predicate searches for a regular expression pattern in a string.

Click here to navigate to the IBM DB2 docs page for this syntax.

Grammar Syntax

Sample Source Patterns

IBM DB2

SELECT EMPNO FROM EMPLOYEE WHERE REGEXP_LIKE(LASTNAME,'luc+?hes+?i','i');

Snowflake

SELECT EMPNO FROM EMPLOYEE WHERE /*** MSC-ERROR - MSCEWI1021 - REGEXP_LIKE NOT SUPPORTED ***/
 PUBLIC.REGEXP_LIKE_UDF('REGEXP_LIKE(LASTNAME,\'luc+?hes+?i\',\'i\')');

  1. MSCEWI1021: Not supported.

Last updated

Was this helpful?