How to use an expression in a Search expression in Advanced search

[#1]

Hello,

I have 3 fields: Model,Kleur and Zoekstring (= Concat(Model, '|', Kleur))

In an inputbox I give a variable a value: '*sport*|*rood*'.

What expression should I use in the Advanced search box of a listbox to filter on the variable to get all the combinations ?

Auke

[#2]

To explain my intentions. I want to give the user a grid (inputboxes) to enter possible combinations to filter on.

I am stuck on how to go further.

[#3 · Accepted solution]

Found a solution, put in the search string:

  = Zoekstring like '*sport*|*rood*' or Zoekstring like 'dames|licht*'

[#4]

Hi, I want to know if we can do the same search, but using in, or something like that.

it will be Zoekstring in (sport*|*rood, dames|licht)

Thanks por your answers.