To retain the Undo option, you must select this option. Make sure that Look in is set to include only those files that you want to modify.Ī reminder is displayed that includes a Keep modified files open option. Clicking any item in this list adds it to the string specified in the Replace with box.Ĭlick this button to replace the current instance of the string specified in the Find what box with the string specified in the Replace with box, and find the next instance within the scope specified in Look in.Ĭlick this button to replace all instances of the string specified in the Find what box with the string specified in the Replace with box, in all files within the scope specified in the Look in box. Click this button to display a list of wildcards or regular expressions, depending upon the Use option selected. This triangular button next to the Replace with box becomes available when the Use check box is selected in Find Options. To include regular expressions in the string specified in the Replace with box, click the Use check box and then click Regular Expressions. Select the drop-down list to display the last 20 items entered. To delete instances of the string specified in the Find what box, leave this field blank. To replace instances of the string specified in the Find what box with another string, enter the replacement string in this field. This box only appears if this dialog box was opened by clicked Quick Replace. To delete instances of the text specified in Find what, leave this field blank. To replace instances of the string specified in Find what with another string, enter the replacement string in this field. These controls enable you to specify what will be inserted in the place of the matched string or expression. Choosing any item from this list adds it to the string specified in the Find what box. This triangular button next to the Find what box becomes available when the Use check box is selected in Find Options. To cause the search engine to interpret your search string as a regular expression, select the Use check box under Find Options and then click Regular expressions. If you want to use wildcards such as asterisks ( *) and question marks ( ?) in your search string, select the Use check box under Find Options and then click Wildcards. You can reuse one of the last 20 search strings by selecting it from this drop-down list. The dialog box attempts to fill in a probable search text, using text selected with the cursor before opening the dialog box, or nearby text, or previously searched-for text. These controls enable you to specify the string or expression that will be matched. Toolbar buttons and shortcut keys are also available to open the Find and Replace dialog box. On the Edit menu, point to Find and Replace, and then click Quick Replace to open the dialog box with both find options and replace options. On the Edit menu, point to Find and Replace, and then click Quick Find to open the dialog box with find options, but without replace options. Versions of the Find and Replace dialog box with slightly different options can appear, depending on how the dialog box was opened. Use the Find and Replace dialog box to locate text within a file and optionally replace it. Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)