Okay, as the title shows, I'm using VB .NET, Access, SQL, and the
LIKE operator.

I am experimenting with the binding source, dataset, and table adapter controls to get the program to behave in the same way that a data access
class would if I had written code in a DA class.

Okay, here is my problem. I have a sql command that isn't working.

Code:
SELECT        Title, Director, YearMade, Description
FROM            MyMovies
WHERE        (Title LIKE '%' + TitleTextBox.[text] + '%')
The TitleTextBox.text is a text box on my form and I want to use the
value of it at runtime to narrow the information in the database down
to only matching requests.

I created this query using the query builder while the program was not
in runtime mode.

This program is just a simple little program to store film information.
So if someone types in "Dumb" into the textbox then
"Dumb and Dumber" and "Dumb and Dumberer" should get returned
to the dataset. [I'm assuming that it is where it gets returned to,
when a query is performed on the database.]

Anyway, if anyone has a solution, please post.

Thanks!