Searching on Phrases with Full-Text MS SQL

In many cases, a single word is not unique enough to narrow down your search results, but a phrase of combined words might return exactly what you want. When choosing a phrase on which to search, consider the following:

For example, to find only those records with the exact word combination Davis Corporation, place the search term in quotes as follows:

“Davis Corporation”

In this example, Versatile only displays entries that contain the words "Davis Corporation" as directly contained within the double quotes. It does not find "Davis" or "Corporation" alone.

Full-text searching with MS SQL allows Boolean operators to be specified and searched within a phrase. For example, “Smith and Jones Company” will find only those items that contain the entire phrase, including the word “and”.

Related Topics