Full text query - multiple terms, multiple columns

Last post 10-08-2008, 4:41 PM by JayintheUK. 0 replies.
Sort Posts: Previous Next
  •  10-08-2008, 4:41 PM Post number 69949

    Full text query - multiple terms, multiple columns

    I need to write a query against the full text catalog.

    Follow this example using Northwind employees where I have FT enabled lastname, firstname and notes columns. Let's say I have entered Churchill, Winston, and Prime Minister.

    I would like to use Winston and Minister as search terms. What is the correct method to query against a row where all terms are found meaning I need to find both term in the row but not necessarily in the same column.

    Cheers!
View as RSS news feed in XML