Searching SQL Results

Use the Find/Replace dialog to search SQL results in the SQL Results view.

  1. In the SQL Results view, toggle to text mode and right-click and select Find/Replace.
  2. Select from these search options:
    Option Description
    Find Enter the data for which you want to perform the search.
    Replace Enter the data with which you want to replace the found data.
    Note: This replaces the data of the displayed result set only. It does not replace the data on the server.
    Direction Select from:
    • Forward
    • Backward
    Scope Select from:
    • All
    • Selected Lines
    Options Choose the search criteria:
    • Case Sensitive
    • Whole Word
    • Regular Expressions
    • Wrap Search
    • Incremental
  3. Click the appropriate button.
    Option Description
    Find Click to find the data.
    Replace Click to replace a selected instance of the found data.
    Note: This replaces the data of the displayed result set only. It does not replace the data on the server.
    Replace/Find Click to find and replace the data.
    Replace All Click to replace all instances of the data.
  4. Click Close when you are finished.
Related concepts
SQL Results View
SQL Results History
Related tasks
Viewing SQL Results
Removing Results from SQL Results View
Grouping SQL Results
Terminating Execution of Procedural Objects and SQL Statements
Filtering SQL Results History
Saving a SQL Result History
Related reference
SQL Results History Fields
SQL Results History Save Options

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com