FullTextSearch for multiple words

Discussion in 'Databases' started by 10inja, Aug 2, 2009.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Hi all, need your help once again.
    I wanted to provide a text box for users to search the database.
    I wanted the search to be "loose" so users can enter a phrase (multiple words) and they will see all rows that contains any of the words.
    I have a asp.net website that uses sql 2008 database. I'm using visual studio 2008.
    I've created a FullTextSearch catalog and one index on all columns of the table.
    I have a table adapter and trying to add a query that will accept a parameter (textboxsearch.text) for the WHERE CONTAINS.. not sure yet if this is the right approach.
    the query builder will not let me add a parameter to the contains or the freetext. It will let me add a parameter to the LIKE, but the problem with using LIKE is that I would have to specify each column for each word and I don't know how many words in advance.

    what can I do?

    I've searched a lot online and haven't found an answer yet.
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page