Chat now with support
Chat with Support

Toad Data Point 5.0 - User Guide

Create New Columns from Existing Columns or Functions

Use Calculated Fields to create a new column that is comprised of 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 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