Chat now with support
Chat with Support

Toad Data Point 5.1 - User Guide

Create New Columns from Existing Columns or Functions

Use Calculated Fields to create a new column that is calculated from other columns or functions and assign the new column to a table in the query.

To create a new column from an existing column or function

  1. Click Edit calculated fields in the Query Builder toolbar.

  2. Review the following for additional information:

    New field name

    Click + to add the column to the list of defined fields.

    Defined fields

    Select a column for which you want to define fields from the list.

    Field definition

    Double-click the columns or calculated fields and the appropriate functions or operators to include in the calculated field (i.e., FIRST_NAME + ’r; ’r; + LAST_NAME).

    Attach to table

    Select the table that you want to attach to the calculated field.

 

Related Topics

Build Queries Visually  

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating