>>Hi Henry
>>
>>You should break yourself of the habit of using .and. and .or.. They are not SQL standards and VFP doesn't need this archaic referencing anymore.
>>
>How should this be handled then Mike. Thanks.

Just drop the . from around the ".and." and ".or." to be left with ...

select * from table where AND condition. The .AND. is old-fashioned.