A script-enabled browser is required for this page to function properly.

Pasting a function (Query Builder)

To paste a function into a condition:

  1. In the Query window, in the Condition field, place your cursor where you want to insert the function.
  2. Click the Paste Function button in the Icon Bar.
  3. Use the Show Categories check boxes to filter the types of functions shown.
  4. Select a function from the list box.
  5. Click the Paste Arguments check box if you want to include default arguments.
  6. Click OK.
  7. In the Condition field, type over the default arguments with the arguments you want to use.

Function example (retrieving names greater than 30 characters)

Suppose you want to list the names of all customers whose names are more than 30 characters long because these names are too long for your mailing labels. To list these names, you create a condition using the LENGTH function. LENGTH counts the number of characters in a character string.

In this example, the argument in the LENGTH function is the NAME column in the customer table. So your function appears in the condition as:

LENGTH (NAME) > 30

Using this condition, Query Builder will evaluate all names in the NAME column and return those where the length of the field is greater than 30 characters.

See also

About Query Builder functions

About conditions (Query Builder)

 

Adding conditions to a query (Query Builder)

 

Condition syntax (Query Builder)

 

Controlling join conditions in linked queries (Query Builder)

 

Creating a negating condition (Query Builder)

 

Creating a nested condition (Query Builder)