Chat now with support
Chat with Support

Quest has tools and processes in place to identify, protect, detect, and remediate vulnerabilities and incidents when they occur, including external security partners. As part of our standard security operations, Quest does not use CrowdStrike in any of our operations. We are reviewing our third parties, and so far, there is minimal affect. It is Quest's policy not to provide further technical details unless they directly impact customer data.

Toad Data Studio 1.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