The target of this query can be of any Ingres data type, including a column or a row of a table field. The data types of the receiving field and the database column from which the data is retrieved must be compatible. If the field or table-field column has the same name as the database column from which the retrieve statement is fetching data, do not specify the field name.

Use the reserved word all in place of the target list in any retrieve statement to assign values to all the simple fields in a form or to all the visible columns of a table field. However, each simple field or table field column in the form must correspond to a database column with the same name and data type.

The database table can contain columns that do not match those in the form, but the form cannot contain unmatched simple fields or table field columns. Append the reserved word all to the tablename, as shown below:

The question mark (?) or asterisk (*) are wildcard characters. The question mark represents a single character while the asterisk represents any number of characters. For a list of comparison operators, see the section, Boolean Comparison Operators in Logical Expressions.