DEFAULT

The DEFAULT function allows a predefined value to be introduced into an expression.

DEFAULT, which is typically used with the EITHER function, returns the value assigned as the default value when the type was defined.

Syntax:
DEFAULT(single-type-expression)
Meaning:
DEFAULT(type_whose_defined_default_value_is_desired)
Returns:
A single-object

Examples

  • DEFAULT(ZipCode)

    In this example, the defined default value for ZipCode is returned. When used with EITHER, DEFAULT might appear like this:

    EITHER( ZipCode,DEFAULT( ZipCode))

    If the first argument evaluates to a value other than "none", that value is used. If the first argument evaluates to "none", the default value for ZipCode is used.