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.