# Query Builder - Expression Builder

The Expression Builder allows you to generate a WHERE clause to specify search criteria for your query. The Expression Builder contains the following elements:

Where Criteria Editor
  Displays the WHERE clause as you construct it using the editor. Also allows you to edit the expression directly.
Table Icon
  Displays all the fields from the selected table, and from other tables above the selected table in the list. Double-click on a field to place it in the Where Criteria editor.
Operators: You can select from the following list to insert operators in your expression:
  = (Equal)
    Constructs an equal (=) operator between fields. Generates this comparison in the Where Criteria editor.
  <> (Not Equal)
    Inserts a not equal (<>) operator between fields. Generates this comparison in the Where Criteria editor.
  < (Less Than)
    Inserts a less than (<) operator between fields. Generates this comparison in the Where Criteria editor.
  > (Greater Than)
    Inserts a greater than (>) operator between fields. Generates this comparison in the Where Criteria editor.
  <= (Less Than or Equal)
    Inserts a less than or equal (<=) operator between fields. Generates this comparison in the Where Criteria editor.
  >= (Greater Than or Equal)
    Inserts a greater than or equal (>=) operator between fields. Generates this comparison in the Where Criteria editor.
  AND
    Inserts an AND operator between two logical expressions in the Where Criteria editor.
  OR
    Inserts an OR operator between two logical expressions in the Where Criteria editor.
  NOT
    Inserts a NOT qualifier on one logical expression in the Where Criteria editor.
  Matches
    Creates a MATCHES operator for character fields in the Where Criteria editor.
  Begins
    Inserts a BEGINS operator between character fields in the Where Criteria editor.
  (...)
    Inserts parentheses ( ) around any selected string in the Where Criteria Editor.
OK
  Accepts the code in the Where Criteria Editor, removes the dialog box, and displays the code in the Expression Builder frame.
Cancel
  Cancels changes and removes the dialog box.

  How to Use Workshop
  WebSpeed Glossary
  WebSpeed Library