Building Expressions

Use the Expression Builder in SQL Query Builder to build simple or complex expressions, or subqueries when creating SELECT, UPDATE, INSERT, and DELETE statements.

Prerequisites 

  1. Connect to the data source through a connection profile.
  2. Open a new or existing SQL file, and be sure to select the connection profile Type, Name, and Database.
  3. Edit an existing SQL statement or create a new one in SQL Query Builder.
Note: Some syntactic variations might exist between your database and the SQL syntax that SQL Query Builder supports; consequently, some SQL Query Builder features might not work with your database.
  1. In the Column cell in which you want to create the expression, select Build Expression, and then click outside the cell to launch the Expression Builder wizard.
  2. Select the expression type and click Next.
  3. Enter appropriate information in the wizard pages.
  4. Once you enter all applicable information, click Finish.
Related concepts
SQL Query Builder
Related tasks
Creating a SELECT Statement
Creating an INSERT Statement From a Values Set
Creating an INSERT Statement From a Subquery
Creating an UPDATE Statement
Creating a DELETE Statement
Editing a SQL Statement
Running the SQL Statement Code
Related reference
SQL Query Builder Preferences
Expression Types