SELECT *; FROM MyTable; WHERE MyField LIKE "*SomeVal*"
str="SELECT * FROM MyTable WHERE MyField LIKE ""*SomeVal*"""
str="SELECT * FROM MyTable WHERE MyField LIKE ""*"& SomeVal& "*"""