Searching for "Contains" in DB Inquiry
RecTrac 3.1.10.18.00
Table of Contents
Problem
We need to search for all activity numbers that contain 4001.
Solution
To search for these activity numbers, format your query using the index function in DB Inquiry. Select the ARActivity table to view then use the following format for your query: index(activitycode,"4001") >0
Steps For Solution
- From the RecTrac main menu, go to DB Inquiry.
- Under Select Table To View select the ARActivity table.
- For your Query, use the format "index(activitycode,"4001") >0"
- Click View.
Your query results should include only activities with an Activity Code that contains 4001.