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