Words and Phrases
Administer > Database Administration > Data persistence > Queries > Use like queries to search for a string of characters
Use like queries to search for a string of characters
Applies to User Roles:
System Administrator
Example: Use a like query in combination with a field function to retrieve all records for vendors/suppliers that begin with the character string DEFAULT.
In this example, we use the like relational operator on the vendor.qbe form to query the vendor field for vendors/suppliers that begin with DEFAULT, followed by any character or character string.
To use like queries to search for a string of characters:
- Click Tailoring > Database Manager.
- Type
=devicein the Form field, and then click Search. - On the Asset Information form, open the More Actions menu.
- Select Expert Search.
- In the Query field, type
vendor like “DEFAULT*”, and then click Search. - Click any record in the list of returned records to view the details.