matches pattern for multiple values


In Business Objects Query Filters, it is possble to say use an IN condition with multiple values


where country in list ('France', 'USA', 'Canada) etc.

However when we have to match sub-strings the matches pattern only allows you to input one value

This means, i cannot do

country matches pattern like ('%SA','Can%')

However such a contains functionality i am told by users exists in other BI products.

Can any one suggest any alternatives or work-arounds?