The NAME attribute of a field or a blob in an SQL table can contain any of the following:

| SELECTNAME=value

| UPDATENAME=value

| INSERTNAME=value

This allows you to specify alternate names for the column the driver will use when generating a SELECT, UPDATE, or INSERT statement.

Example:

hid STRING(4001),NAME('hid | SELECTNAME=hid.ToString()')

This will cause the driver to generate “hid.ToString()” when issuing a SELECT statement, but just “hid” when issuing an INSERT or UPDATE statement.