Database Wild Cards
For character columns, the SQL 'LIKE' clause can be used with wild card characters '%' and '_'.
Most of Agate III's character prompts allow for partial field entry. Agate III appends these prompts with a '%', and generates a database selection using a 'LIKE' clause, retrieving all data starting with the characters entered.
When a user enters a % followed by characters in a prompt, the database selection retrieves all data where these characters occur anywhere in the field.
Refer to a SQL reference manual for more detailed description of database wild card capabilities.