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!