Open topic with navigation

Learn more about Toad for SQL Server at Dell Software Find solutions and downloads at the Toad for SQL Server Support Portal

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  

of