Creating computed columns in a query

To create a computed column in a query, follow the steps below:

  1. In the Query Editor window, select Create Computed Column from the Column menu. The Create Computed Column dialog will then appear. See the dialog.
  2. Input a name for the column in the Computed Column Name text box.
  3. Compose your functions for the column.
  4. When done, click the OK button to create the computed column.

Notes: