Search engine

I am trying to search a SQL Server 2008 database table based on user input into a texbox. I have already tried using the clause LIKE ‘%x%’, but it’s not useful when the user types in multiple words. I want my search engine to be able search keywords in the database. I read about FREETEXT and CONTAINS, but im not sure if that will work.

Please help me..Thanks in Advance.

Read More >>