# Find Documents by Search Term Examples for SQL Server

Below are examples on how to find documents by Search Term using the SQL Server database:

insurance

Will return documents that contain the search term insurance.

auto insurance

Will return documents that contain the search term auto insurance.

auto or home

Will return documents that contain auto or home.

+auto +home

auto and home

auto & home

Will return documents that contain auto and home.

+insurance -auto

insurance not auto

Will return document records that contain insurance and not auto

grocer*

Will return documents that contain the term, beginning with grocer.

fruits near vegetables

Will return documents that contain fruits located near vegetables.

For more examples and additional usage information, please see the SQL Server documentation.

Notes on special characters:

- * is a multiple wild card character;

- Parenthesis characters () can be used to group words into sub-expressions.

Additional Information:

- The CONTAINS predicate is used for Full-Text searches.