• Hey Lowell,

    that´s a good page, though it didn´t help me yet. Isn´t there a way simple way to follow the below example from the page in a way that keeps the `in between´ content of a word open to anything:

    "The following query returns the first and last names for those employees with a first name of Steven or Stephen (where first_name begins with Ste and ends with en and in between is either v or ph):

    SELECT first_name, last_name

    FROM employees

    WHERE REGEXP_LIKE (first_name, '^Ste(v|ph)en$');

    "

    In my example, it could be something like

    'coop(%)ration'

    and filter out all words that start with coop and end with ration. This would avoid the nasty special character problem. Unfortunately, it won´t work.

    Or did I possibly not fully understand your reply?:-) Thanks anyway