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.