Regexp SQL Filter in Eloqua Insight

Hello,

I'm currently setting up a report in Eloqua Insight on my Contact Database.

I want to put a filter on the phone number column, and only get results for contacts with a phone number matching the regular expression ^(0|\+33)[1-9]([-. ]?[0-9]{2}){4}$.

I tried two ways to do so :

• Set it up with the filter operator is LIKE and putting in the SQL Expression
• Convert the filter to SQL with a WHERE clause

It did not work out so far. I have very little knowledge of SQL so I'm probably doing it wrong.

Does any of you know how to set it up to make it work ?