Keyword search with SQL Server

asp.net, keyword, linq, search, sql-server

Solution

Easily the best and most comprehensive article on the subject : http://www.sommarskog.se/dyn-search-2005.html

Problem

I have a scenario where I need to search for cars by keywords using a single search field. The keywords can relate to any of the car's attributes for e.g. the make or the model or the body style. In the database there is a table named 'Car' with foreign keys referencing tables that represent models or makes or body style. What would be the best way of doing this? Specifically, How should I take the query from user(must support exact phrase search, or, and) and how do I actually do the search. I am using SQL Server and ASP.NET 3.5 (Data access using LINQ)

Original source