Null Case function

    This toolbar button will insert the syntax for Null Case conditional in the SQL pane, for example in the case of MS-SQL Server this string is as follows:

COALESCE(Fld, vNullCaseValue)

where Fld is the selected field in the Columns pane and vNullCaseValue must be replaced with a proper value, which will handle the case when the field Fld is NULL.

Note that in Oracle this Null Case function is as follows:

            NVL(Fld, vNullCaseValue)