When searching the database, consider the following hints for search strings, operators, and wildcard characters to help you find exactly what you want:
-
Search strings are not case sensitive.
-
Several operators and wildcard characters are supported in searches. This support can vary based on the type of search, such as object name or text searches.
-
Database and file searches use the SQL Server full-text search engine, which dictates the rules regarding operator and wildcard character use.
-
You can use wildcard characters as a prefix or suffix in full-text searches, such as *FC or FC*.
-
Do not use operators in object name searches.
-
The search results can contain zero, one, or many items.
-
Each item listed in the search results provides a link to view the item.
For more information, see Search Operators and Wildcard Characters.