A script-enabled browser is required for this page to function properly.

Define Column dialog box

The Define Column dialog box enables you to create a new column in your query based on values in another column. Defined columns appear in both the Data source panel and the Results window.

This dialog box contains:

Defined Columns

Specifies the name of the column you want to create.

List box

Lists existing defined columns.

Defined as

Specifies the expression of the selected column.   The expression typically consists of a function or operation and the database column(s) to be operated on. If the column name occurs in more than one table, remember to reference the table name as well, and separate it from the column name with a period.   If the column name is unique, you can specify just the column name.

Define

Applies the definition to the column.

Remove

Deletes the selected column.

Paste Column

Displays the Paste Column dialog box.

Paste Func

Displays the Paste Function dialog box.

Usage notes