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

Define Column Dialog

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 Datasource 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.
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.
 
Note: The defined column is only a part of your query and will not modify the table definition saved in the database.

Building a New Query

About the Query Window

Defining a Column

Removing a Column