The Function Builder contains a list of standard database functions, operators, user defined functions and all columns belonging to all source tables.

Expanding the Function Heading displays the Function Groups (Number, String, Data, Conversion, etc) and the Re-usable Function Heading. Similarly, expanding the Data Heading displays Source Tables.

Each function group or source table can in turn be expanded to show individual Functions and Source Columns.

Double clicking on a function adds the Function Model to the Function SQL Text Window. The first variable (almost always the source column) is left highlighted in the Function SQL Text Window. This allows additional Functions or Source Columns to be added to the correct place in the Function SQL Text Window by double clicking on the required Function or Source Column in the Function Builder.