If you have a pattern that is too complex for LIKE to handle, you can use the regular expression pattern patch function: REGEXP_LIKE().

The following script provides you some good examples:

SELECT CASE WHEN REGEXP_LIKE ('rendc.org', '.*ggl.*',

'i') THEN 'TRUE' ELSE 'FALSE' END FROM DUAL;

TRUE

SELECT CASE WHEN REGEXP_LIKE ('rendc.org', '.*com$',

'i') THEN 'TRUE' ELSE 'FALSE' END FROM DUAL;

TRUE

SELECT CASE WHEN REGEXP_LIKE ('rendc.org', '^F.*','i')

THEN 'TRUE' ELSE 'FALSE' END FROM DUAL;

TRUE