peter.row (7/25/2013)
I was caught out by words like "the", "to" etc... which I thought would not be counted by near given that common words like those are generally not considered by fulltext searches.
Given that the default for NEAR is that word order doesn't count and the search term didn't force order to be considered, ignoring trivial words would have led to all four phrases matching; but the question stated that only two would match, which meant that the trivial words must count. So being caught out like that was somewhat careless of you. :hehe:
Tom