Search.

I'm working on an ASP.NET 2.0 program. All my data is contained in a SQL database. It nicely displays the results in a GridView, but now I want to work on not only filtering those results but also sorting them. Is anyone aware of any 2.0 code that exemplifies how best to do this.
It should be pretty easy to create code that searches, just add something to my stored procedures select statement like:
select * from Game where Title LIKE varSearchTerm or Description LIKE varSearchTerm
But what about doing AND/OR searching, e.g.:
User enters: "Tag Dodgeball" (quotation marks indicating both terms together are required"
User enters: Tag AND Dodgeball (AND indicates both terms are required somewhere)
User enters: Tag OR Dodgeball (OR indicates only one term is required).
David.

Thanks Mart. The one difficulty with OpenLucene is it appears to be focused on indexing documents rather than database contents. I'll investigate it further when I have a chance though.
David.