>>>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.