Querying an 'enter multiple' custom field


I have a question regarding querying of ‘enter multiple values’ custom
fields. What possibilities do I have to query such custom fields for
a single value in a multi-value entry? Is the value simply stored as
a large text field?

I have the problem, that some values might contain other possible values,
in the sense of ‘Machnine11’ containing ‘Machine1’.

So, given the field value (2 values) ‘Machine11; Machine2’ a query

… LIKE ‘Machine1’

would match this value.

Bottom line: is there any other possibility besides LIKE to query
for individual values of an enter-multiple custom field?

Thanks in advance.


Jan Algermissen http://www.topicmapping.com
Consultant & Programmer http://www.gooseworks.org