With the multiple choice fields you need to include all possible values. Meaning your LIKE statement needs to have:
FieldName LIKE '%|a1|%' OR FieldName LIKE 'a1|%' OR FieldName LIKE '%|a1'
You do this because with a multichoice field, you can have 1 or many items in the field.
For example, if the data in the field was:
a1|e1|d1
The LIKE
evaluation of '%|a1|%'
would not get the value. BUT the LIKE
evaluation of 'a1|%'
would.
Same would be true for looking for the value of d1
. The LIKE
evaluation of '%|d1'
would be the only evaluation which would capture that value existed in the string.