Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal
< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7
You are here: Build Queries Visually > Create New Columns from Existing Columns

Create New Columns from Existing Columns

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