>Dear Long,
>
>The syntax for locate for should be:
>
>Locate for TheField=TheSearchString
>
>Typically, I would write as
>
>Select TheTable
>Locate for TheTable.TheField=&TheSearchStringA .and. TheTable.TheField=&TheSearchStringB ....etc.
>
>Good Luck
>
Hi Ransome,

Your LOCATE would find anything only if TheSearchStringA = TheSearchStringB or TheSearchStringB = TheSearchStringA.