I spent my one day trying to figure out if MM implements searching a sub-string that is equivalent to the ouput of the given SELECT-SQL below.

Select vendor_no from apvend01 where vendor_no like "%1%"

I just want to confirm if MM doesn't really have this feature so that I know that I have to write my own codes for this. At first, I thought that property "clocateExpression" will do the job.

Nerissa