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

>
>SELECT * FROM mytable WHERE myfield LIKE "%xyz%"
>

Thanks Sergey. Seems to work good.