this works, thanks.
Code:
LIKE '%" & MyVar & "%'