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