>>>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.
OK Thanks Mike.
- Ravi
True greatness consists in being great in little things.
- Charles Simmons