Administer > Database administration > Data persistence > Queries > Use the starts with relational operator

Use the starts with relational operator

Applies to User Roles:

System Administrator

Example: Retrieve all capability words that begin with the letter p.

In this example, we execute a starts with query for all capability records where the capability field on the Capability Word form begins with the letter p.

To use the starts with relational operator:

  1. Click Tailoring > Database Manager.
  2. Type capability in the Form field, and then click Search.
  3. Double-click the capability form in the records returned.
  4. Type p in the Capability field on the Capability Word form, and then press Enter.
  5. Click any record to view the details.

Note: Results returned are case-sensitive and return only matches for the case used in your query string, unless your database is first set up for case-insensitive searching.

Related topics

Record retrieval
Relational operators
Retrieving records by using the record list method
Starts with relational operator
The Database Manager utility

Retrieve all records in a table
Retrieve records within a range