Hello, I am stuck as an ASP noob with my asp search engine, searching a database. I have set up a SQl like query with a wildcard, but it doesnt return the results in the way that i'd like. I want it like this:

Search for apple, get back results such as apple, apple pie, apple crumble, but i dont want to search for A and get everything.

Thanks