Searching for Multiple Keywords Without Using ‘AND’ in Full-Text Search with MS SQL

When using full-text search with an MS SQL database, you cannot enter multiple words without using ‘AND’. For example, the following does not work:

• this that

In combination with other operators, full-text search with MS SQL also applies a strict ‘AND’ search. Therefore, the following will not work either:

• this (a OR b)

• a b OR c

• a (b OR c)

• a b AND NOT c

• a AND (b c)

The following expressions will work:

• this AND (a OR b)

• a OR b

• a AND b

• a AND (b OR c)

• a OR (b AND c)

• a AND (b AND NOT c)