Administer > Database administration > Data persistence > Queries > Use the lng function in a query

Use the lng function in a query

Applies to User Roles:

System Administrator

Example: Retrieve operator records where the length of the operator name is longer than five (5) characters.

In this example, we use the lng function to specify the length of character strings in the operator.qbe form and then performs an Advanced Search for records matching that criteria.

To use the lng function in a query:

  1. Click Tailoring > Database Manager.
  2. Type =operator in the Form field, and then click Search.
  3. On the Operator Record form, open the More Actions menu.
  4. Select Expert Search.
  5. In the Query field, type lng(name)>5, and then click Search.

    Note: This lng query is the same as typing name like ‘??????*”

  6. Click any record in the list of returned records to view the details.

Related topics

Record retrieval
Relational operators
The Database Manager utility
Using functions in a query
More Actions menu

Use the index function in a query
Use the lng function in a query
Use the tod function in a greater than or less than query

Service Manager Programming