Narrowing a search for SQL syntax

You can use SQL view to search for specific syntax in the SQL for a report. Use any of the following options to narrow the results you get from a search using the Find feature. These options work similarly to Find options in Microsoft Notepad.

To view a report in SQL view, open a report and select SQL View from the View menu.

Matching the whole word

Match whole word only finds only strings that match all of the text you enter in the Find what text box. For example, if you enter "temporary", a string containing "temp" will not be found.

Making a search case-sensitive

Match case finds only text that has the same pattern of upper and lower case as the text you specify in the Find what text box. Use this option to make the search case-sensitive.