>>>When working with an Access table, is there an equivalent SQL SELECT to VFP's "contained in " syntax? That is
>>>
>>>SELECT * FROM mytable WHERE "xyz"$myfield
>>>
>>>Thanks
>>
>>Try to use standard SQL
LIKE operator
>>
>>
>>
>>SELECT * FROM mytable WHERE myfield LIKE "%xyz%"
>>
>
>Thanks Sergey. Seems to work good.
You're welcome.
--sb--