And/or keyword when search with ASP.NET

Question

I'm now writing a searching application on C#/ASP.NET.

User inputs a keyword into a textbox, and then my app finds appropriate results from SQL Server through ADO.NET.

I want to implement ability to search using AND/OR keyword in my application.

For example:

Now my users can input a keyword such as "Cisco". Now they want to search with "Cisco AND Microsoft" or "Cisco OR Microsoft"

How can I do this?

Answer 1

Are you sure you want to use SQL Server for search? Consider Lucene.NET

Answer 2

Full text search and contains?

Answer 3

check out Erland Sommarskog - Dynamic Search Conditions in T-SQL