Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Work with Data > Find and Replace Text

Find and Replace Text

To find and replace text

Press CTRL+F in the Editor.

or

Select a row or cell in the Data/Results tab, or any tab in the Database Explorer, and press CTRL+F.

Tip: When working with data in the Data/Results tab or tabs in the Database Explorer, you can also filter the columns to locate text more easily. See Filter Data for more information.

Review the following for additional information:

Mark individual cells	(Data grid only) Select this checkbox to highlight individual cells that match the search term instead of the entire row.
Mark with bookmarks	(Editor only) Select this checkbox to add a bookmark to any line where the search term is present.
Use regular expressions	Select this checkbox to search using regular expressions. See Supported Regular Expressions for more information.

Tip: To remove the green underscore () from the Editor if you used the Mark All option, select Edit | Find and Replace | Clear Find Marks from the menu.