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
This tool will select or delete the records that match specified criteria. It can also use them to create a new table.
Connection
Sets the database connection properties. This option allows you to choose the name of the connection from the drop-down list.
Table name
Sets the name of the table.
Column name
Select a column to search through all records.
Action
Description
Remove
Deletes all records that match the specified criteria from the table.
Select
Selects the records that match the specified criteria.
Create Table
Creates a new table with the results of the search.
Criteria
The program will select only those records that match the given condition.
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.
Keywords
The program will select only those column values that fully correspond to the defined keywords.
Result table name
Sets the name of the new table.
Filter type
Determinates whether the program would include only those records that satisfy or DO NOT satisfy the condition.
Related Topics:
Advanced settings
Schedule package for later execution
Scheduling options
Repair E-mail Addresses
Search and Replace
Compare Tables
Filter Through Text File
Remove Duplicate Recipients
Remove Duplicate Records
Execute SQL Query
Copyright © 1997-2005 Gate Comm Software. All Rights Reserved.
