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,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com