Jack Corbett (1/8/2010)
But wouldn't using CONTAINSTABLE(table, *, N'123 AND Apple AND Street AND FL AND 33647', 50) do the same thing as adding a column to Full Text on with the entire address because it will search all the columns in the FT Index for those search terms?
Hey Jack,
Sadly, no. The full text search is applied to each column in turn when star is specified, not over all columns at once. So, the ANDed conditions would need to match data in just one of the columns. This may be slightly counter-intuitive, but there you go.
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi