Finding a Text String in the Query Window - SQL Assistant

Finding a Text String in the Query Window

You can find specific text strings in the Query Window using the Find dialog. You may search for strings using regular expressions or wildcard characters in addition to specific text.

To find text in the Query Window

1 With the Query Window active, do one of the following:

On the toolbar, click .

Select Edit > Find from the menu bar.

Press Ctrl+F.

2 Enter the desired text string in the Find what field. If you want to build a regular expression, you can access predefined strings by clicking the solid arrow to the right of this field and selecting the expression you want inserted.

3 Choose from the following options:

Whole word only - finds text only where a whole word matches the search string

Match case - finds text that only matches the case of the search string

Search selected text only - restricts the search to the currently selected block

Search hidden text - searches within hidden [collapsed] text also

Regular Expression - searches for strings that match a regular expression

Use Wildcards - allows the use of wildcard characters:
? - any single character
* - any number of characters
# - any single digit
[xyz] - any one character in the set
[!xyz] - any one character not in the set

4 Specify the search direction by selecting Direction up or down.

5 Click Find Next to locate the string.

To locate consecutive strings, click Find Next or press F3.

6 Click Mark All if you want to place a bookmark on each line containing the search string.

7 Click Close to close the dialog.