Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » UltraLite - Database Management and Reference » UltraLite SQL Reference » UltraLite SQL functions » SQL functions (A-D)


ARGN function [Miscellaneous]

Returns a selected argument from a list of arguments.

ARGN( integer-expression, expression [ , ...] )
  • integer-expression   The position of an argument within the list of expressions.

  • expression   An expression of any data type passed into the function. All supplied expressions must be of the same data type.


Using the value of the 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/2003   Vendor extension.


The following statement returns the value 6.

SELECT ARGN( 6, 1,2,3,4,5,6 );