BaseNow

 

  Search
   

  Help

Screen shots

Compare editions

Online help

Quick-start videos

System requirements

License agreement

Known issues

  Support

 Forums

Technical support

Feedback

 About the author

 Company

Contact

Privacy policy

  Features

BaseNow architecture

Database tools

BaseNow Agent

Tables and views

SQL Query Builder

Import/export data

  Subscribe

Stay informed about any major changes. Click here to subscribe

 

Find a value in a column

1. Click the Find  button on the toolbar or press CTRL+F on your keyboard.

2. In the Find What box, type the value you want to find.

If you do not know the exact value you want to find, you can use the Any Part of Field option in the Match drop-down list.

3. Set any other options you want to use in the Find and Replace dialog box.

4. Click Find.

Find button

After you click the Find button the program will select records that match the specified criteria. When the first value is found, the button changes the caption to Find Next. Every time you click it, the program finds the next record.

Find All button

If you click the Find All button, the program selects all records that match the specified criteria at once.

Options

Find What

Enter the information you want to search for.

Look In

Select a column to search through all records. This is usually quicker, especially if the column is indexed. Or, select the All Fields option to search through all columns in all records.

Match

Select one of the match types:

Match type

Example

Any Part of Field

"berg" finds Bergen and Heidelberg.

Whole Field

"London" finds London, but not Londonderry.

Start of Field

"berg" finds Bergen, but not Heidelberg.

Does not contain

Finds the records that do not contain the specified value.

Greater Than

"3" finds 4, 5, 6

Less Than

"3" finds 1, 2

Is Null

Finds all records where the specified column does not contain any value.

Before Date

Finds values before specified date.

After Date

Finds values after specified date.

Note: you cannot use ’Any Part of Field’ and ’Start of Field’ criteria with numeric columns.

Search

Select a search direction: Up (toward the first record), Down (toward the last record), or All (through the entire table).


Related Topics:

About Search and Replace tool

Replace values in a table

Using criteria to retrieve certain records

Compare Tables

Using wildcard characters

[Home] [Download] [Screen Shots] [Details] [Support] [Purchase]

Copyright © 1997-2005 Gate Comm Software. All Rights Reserved.