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

 

Using criteria to retrieve certain records

A criteria is a combination of symbols identifiers, operators, and values that produce a result. You can use search criteria to restrict the number of rows returned by a query. You use criteria in a WHERE or HAVING clause that specify the conditions that the source rows must meet to be included in the SQL statement.

Most commonly the expression consists of an operator and a search value. For example, to find customers in a particular sales region, you might specify the following search criterion for the region column:  ='Asia'

To specify conditions

1. Add the columns or expressions that you want to use within your search condition to the Grid pane. If you do not want the search columns or expressions to appear in the query output, clear the Output column for each search column or expression to remove them as output columns.

2. Locate the row containing the data column or expression to search, and then in the Criteria grid column, enter a search condition. If you do not enter an operator, the program automatically inserts the equality operator "=".

Expression Builder is a tool that helps you build a search criteria. For more information about it, see Expression Builder.


Related Topics:

How to create a view

About SQL Query Builder

SQL Query Builder Layout

Add or remove a table

Add a column

Customize the table and view names

Customize the column names

Expression Builder

Using wildcard characters

Comparison operators

Logical operators

Mathematical operators

Show or hide a column in a view's results

Group Rows in query results

Results Pane

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

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