" select CategoryName from Categories where CategoryName like *E*"
It's throwing an unhandled exception.>SELECT *; > FROM MyTable; > WHERE MyField LIKE "*SomeVal*" >>or
>str="SELECT * FROM MyTable WHERE MyField LIKE ""*SomeVal*"""
>
>or>str="SELECT * FROM MyTable WHERE MyField LIKE ""*"& SomeVal& "*""" >