| **Navigation:**  SQL Drivers >====== SELECTNAME, UPDATENAME, INSERTNAME ====== | [[checkfornull.htm|{{btn_prev_n.gif|Previous page}}]][[coming future.htm|{{btn_home_n.gif|Return to chapter overview}}]][[date and time column considerations.htm|{{btn_next_n.gif|Next page}}]] |
|  ||

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.