Search in the SSMS results grid

Last modified: August 5, 2024

The Search feature in the SSMS results grid allows searching for matching data, whole words, and regular expressions by the specified value.

To access the Search feature, right-click the results grid and then select Find or press Shift+Alt+F.

Show a search box with options

In the search box that opens, you can customize the search by selecting the following options:

Match Case button Match Case to make your search case-sensitive.

Whole Words Match whole word to search for an exact word or phrase.

Regular Expressions Use Regular Expressions to set the search with RegExp.

SQL Complete highlights the search results in the results grid.

To navigate through the search results, use the Find previous and Find next options Find previous and Find next buttons.

To close the search box, click Close button Close.

Watch the video to see how to search for data in the results grid.