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.
Please help me..Thanks in Advance.