Screen shots

Compare editions

Online help

Quick-start videos

System requirements

License agreement

Known issues



Technical support


 About the author



Privacy policy


BaseNow architecture

Database tools

BaseNow Agent

Tables and views

SQL Query Builder

Import/export data


Stay informed about any major changes. Click here to subscribe


Expression Builder

You use the Expression Builder dialog box to generate an criteria you would use in the SQL query statement. In the Grid pane in SQL Query Builder, click the column where you want to enter an expression and then press the Build button on the toolbar.


In the upper section of the builder is an expression box where you build the expression. Use the lower section of the builder to create elements of the expression, and then paste these elements into the expression box to form an expression. You can also type parts of the expression directly into the expression box.


In the left section of the builder are commonly used operators. If you double-click one of the operators, the Expression Builder inserts the operator at the insertion point in the expression box.


If you double-click a function in the left box, the expression box inserts the function at the insertion point in the expression box. The right box lists the values and parameters, if any, for the elements you select in the left box.


In the left section of the builder are some of the keywords used in SQL queries. Double-click the keyword to add it to the expression box.

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

Using criteria to retrieve certain records

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.