ARGN Function [Miscellaneous]

Returns a selected argument from a list of arguments.

Syntax

ARGN ( integer-expression, expression [ , …] )

Parameters

Parameters
Parameter	Description
integer-expression	The position of an argument within a list of expressions.
expression	n expression of any data type passed into the function. All supplied expressions must be of the same data type.

Returns

Using the value of the integer-expression as n, returns the nth argument (starting at 1) from the remaining list of arguments.

Remarks

Using the value of integer-expression as n returns the nth argument (starting at 1) from the remaining list of arguments. While the expressions can be of any data type, they must all be of the same data type. The integer expression must be from one to the number of expressions in the list or NULL is returned. Multiple expressions are separated by a comma.

Standards and Compatibility

SQL—Vendor extension to ISO/ANSI SQL grammar.
Sybase—Compatible with Adaptive Server.

Example

The following statement returns the value 6:

SELECT ARGN( 6, 1,2,3,4,5,6 ) FROM iq_dummy