Nerissa,

>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.

There's no limitatio on what you can do with Mere Mortals with regard to SQL SELECT statements. You can either create a view or use SQL pass through to execute this command.

Regards,