Sybase Adaptive Server Anywhere - Page 332

Alphabetical list of functions
314
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.
The following statement returns the value 6.
SELECT ARGN( 6, 1,2,3,4,5,6 )
Using the value of the integer-expression as n, returns the n’th 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.
♦
SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
ASCII function [String]
Returns the integer ASCII value of the first byte in a string-expression.
ASCII ( string-expression )
string-expression The string.
The following statement returns the value 90.
SELECT ASCII( ’Z’ )
If the string is empty, then ASCII returns zero. Literal strings must be
enclosed in quotes.
♦
SQL/92 Vendor extension.
♦
Sybase Compatible with Adaptive Server Enterprise.
ASIN function [Numeric]
Returns the arc-sine, in radians, of a number.
ASIN ( numeric-expression )
Function
Syntax
Parameters
Examples
Usage
Standards and
compatibility
Function
Syntax
Parameters
Examples
Usage
Standards and
compatibility
Function
Syntax