Hi All

I have a field that is created as a Multiselect field, commaseperated.
I want to create a list that searches for a specific entry in this list, but which parameter should I use? Or should I use advanced, and how do I create that filter?
Btw. I found some old posts saying that I had to put % around the text I want to search for, that didn't change anything.

Nobody knows? Or it's impossible?

And as far as I can see I've been through most of them without any luck.
Most of them are about CB1.2, so I guess there could be a difference, so I'm a bit lost on this...

The field is called 'cb_certificationlevel' Title of the field is 'Certifikatnavn'.
The values I've given are:
Intet
Open Water Diver
Adventure Diver
Nitrox
Advanced Open Water Diver
Emergency First Responder
Rescue Diver
Master Scuba Diver
Divemaster
Assistant Instructor
Open Water Scuba Instructor
Master Scuba Diver Trainer
IDC Staff Instructor
Master Instructor
CMAS *
CMAS **
CMAS ***
CMAS Instructor

I would like to make a cople of lists that contains people that have specific fields set.

One list 'Nitrox'
Another list
'Open Water Suba Instructor' OR 'IDC Staff Instructor' OR 'Master Instructor' OR 'CMAS Instructor'

Hmm, while writing this I just thought of testing with the field name instead of the title that the simple query uses.
And now it works, arh darned, sorry.

So the 'Advanced' query that looks like

FIELDTITLE = '%VALUE%' works.

and the query with FIELDNAME is wrong, and won't work in 'Advanced'.

The OR query is still wrong though:
'cb_certificationlevel' LIKE '%Open Water Suba Instructor%' OR 'cb_certificationlevel' LIKE '%IDC Staff Instructor%' OR 'cb_certificationlevel' LIKE '%Master Instructor%' OR 'cb_certificationlevel' LIKE '%CMAS Instructor%'