Basically I am looking for a way to use an SQL query to access my Access database and find in a collumn of product names, a series of lines that contain a refrence to the passed string...(i know this isn't very clear so here is an example of what I mean).
I pass the query the word "sign" and I have a column that contains product names. Like:
Clear the Signs
And the query would return rows 1, 3, 5; is there a way to format a query to do this. Or should I query the entire database and then have my application loop through the results and find the index of that string. My only worry here is that it will have a huge imact on memory if I have to bring the entire database into the application. Please help.