Archived discussions are read-only. Learn more about SAP Q&A

matches pattern for multiple values

Hello,

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

example:

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?

Not what you were looking for? View more on this topic or Ask a question